i want to select only one radio button based on gridview row selection
 |
onselectedindexchanged="ddlTitle_SelectedIndexChanged"> |
| | ||
onselectedindexchanged="ddlTransactionType_SelectedIndexChanged"> | | Width="84px" /> |
Width="579px" AllowPaging="True" AutoGenerateColumns="False" ShowFooter="True" EmptyDataText="No Records found !!" style="margin-left: 30px" onrowdeleting="gvGeneralCollection_RowDeleting" onrowdatabound="gvGeneralCollection_RowDataBound" > CommandName="Delete" runat="server" OnClientClick="javascript:return confirm('Do you really want to \ndelete the item?');"> Delete |
oncheckedchanged="rbCreditCard_CheckedChanged"/> oncheckedchanged="rbDebitCard_CheckedChanged" /> oncheckedchanged="rbAmountCollectLater_CheckedChanged" /> |
AutoPostBack = "true" ForeColor="#000099">
Width="787px"> EmptyDataText="No Records found !!" ForeColor="#333333" GridLines="None" Height="289px" ondatabound="gvCollection_DataBound" onprerender="gvCollection_PreRender" onrowcommand="gvCollection_RowCommand" onselectedindexchanged="gvCollection_SelectedIndexChanged" ShowFooter="True" Width="482px"> Position="Top" PreviousPageText="Previous" /> SelectCommand=" SELECT COLLECTION_TRANS.ReceiptNo, COLLECTION_TRANS.ReceiptDate, COLLECTION_TRANS.DoctorID, COLLECTION_TRANS.Charge,payment_details.Patient_ID, payment_details.Payment_Type, payment_details.Amount, payment_details.Cheque_No, payment_details.Cheque_Date,payment_details.Banker, payment_details.DateCreated, payment_details.Remarks FROM COLLECTION_TRANS INNER JOIN payment_details ON COLLECTION_TRANS.HospitalNo = payment_details.HospitalNo" FilterExpression="{0} LIKE '{1}%'"> |
below is my aspx.cs code
public partial class GeneralCollection : System.Web.UI.Page
{
decimal grdAmount = 0;
private string PatientType = "";
private string PaymentType = "";
private string SearchString = "";
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
VisitType();
TransactionType();
ReceiptNo();
PatientName();
ConsultedDoctor();
Grid_clear();
txtReceiptNo.ReadOnly = true;
txtDate.Enabled = false;
txtHospitalNo.ReadOnly = true;
ddlVisitType.Enabled = false;
ddlPatientName.Enabled = false;
ddlTitle.Enabled = false;
ddlTransactionType.Enabled = false;
txtCharge.Enabled = false;
txtSum.Enabled = false;
txtVideNo.Enabled = false;
ddlConsultedDoctor.Enabled = false;
txtDrawnOn.Enabled = false;
txtDated.Enabled = false;
txtRemarks.Enabled = false;
cmdModify.Enabled = false;
cmdDelete.Enabled = false;
cmdDelete.Attributes.Add("OnClick", "return WarningDelete()");
lblSearchRecords.Visible = false;
//User = Request.QueryString["txtuser"];
// this.txtDrawnOn.Text = Request.QueryString["txtuser"];
}
}
protected void ReceiptNo()
{
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
string strSQL = "Select MAX(CID) from COLLECTION_TRANS ";
SqlCommand cmd = new SqlCommand(strSQL, sqlConn);
object No = cmd.ExecuteScalar();
if (No == DBNull.Value)
{
txtReceiptNo.Text = "1";
}
else
{
int m = Convert.ToInt32(No.ToString());
int n = m + 1;
txtReceiptNo.Text = n.ToString();
}
sqlConn.Close();
}
protected void VisitType()
{
ddlVisitType.Items.Clear();
string strSQL;
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
strSQL = " select VisitName from VisitTypes ";
SqlCommand cmdRoomType = new SqlCommand(strSQL, sqlConn);
ddlVisitType.Items.Add("<======Select=====>");
SqlDataReader dr = cmdRoomType.ExecuteReader();
while (dr.Read())
{
ddlVisitType.Items.Add(dr[0].ToString());
}
sqlConn.Close();
}
protected void TransactionType()
{
ddlTransactionType.Items.Clear();
string strSQL;
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
strSQL = " select TypeName from TransactionType ";
SqlCommand cmdRoomType = new SqlCommand(strSQL, sqlConn);
ddlTransactionType.Items.Add("<======Select=====>");
SqlDataReader dr = cmdRoomType.ExecuteReader();
while (dr.Read())
{
ddlTransactionType.Items.Add(dr[0].ToString());
}
sqlConn.Close();
}
protected void ConsultedDoctor()
{
ddlConsultedDoctor.Items.Clear();
string strSQL;
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
strSQL = "select Name from doctor_details";
SqlCommand cmdConsultedDoctor = new SqlCommand(strSQL, sqlConn);
ddlConsultedDoctor.Items.Add("<============Select==========>");
SqlDataReader drConsultedDoctor = cmdConsultedDoctor.ExecuteReader();
while (drConsultedDoctor.Read())
{
ddlConsultedDoctor.Items.Add(drConsultedDoctor[0].ToString());
}
sqlConn.Close();
}
protected void PatientName()
{
ddlPatientName.Items.Clear();
string strSQL;
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
strSQL = "select Patient_Name from registration_details";
SqlCommand cmdPatientName = new SqlCommand(strSQL, sqlConn);
ddlPatientName.Items.Add("<============Select==========>");
SqlDataReader drPatientName = cmdPatientName.ExecuteReader();
while (drPatientName.Read())
{
ddlPatientName.Items.Add(drPatientName[0].ToString());
}
sqlConn.Close();
}
public static string DoctorID(string strDoctorCode)
{
string Code = "";
string strSQL;
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
strSQL = " select RegID from doctor_details where Name='" + strDoctorCode + "'";
SqlCommand cmdTestHeads = new SqlCommand(strSQL, sqlConn);
SqlDataReader drTestHeads = cmdTestHeads.ExecuteReader();
if (drTestHeads.Read())
{
Code = drTestHeads[0].ToString();
}
sqlConn.Close();
return Code;
}
public static string PatientCode(string strPatientId)
{
string Code = "";
string strSQL;
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
strSQL = " select RegID from registration_details where Patient_Name='" + strPatientId + "'";
SqlCommand cmdTestHeads = new SqlCommand(strSQL, sqlConn);
SqlDataReader drTestHeads = cmdTestHeads.ExecuteReader();
if (drTestHeads.Read())
{
Code = drTestHeads[0].ToString();
}
sqlConn.Close();
return Code;
}
protected void ddlTransactionType_SelectedIndexChanged(object sender, EventArgs e)
{
string strSQL;
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
strSQL = "select Charge from TransactionType where TypeName='"+ddlTransactionType.SelectedItem.ToString()+"'";
SqlCommand cmdWardDetails = new SqlCommand(strSQL, sqlConn);
SqlDataReader drWardDetails = cmdWardDetails.ExecuteReader();
if(drWardDetails.Read())
{
txtCharge.Text = drWardDetails[0].ToString();
}
sqlConn.Close();
}
protected void ClearFields()
{
txtReceiptNo.Text = "";
txtDate.Text = "";
txtHospitalNo.Text = "";
ddlVisitType.SelectedIndex = 0;
ddlPatientName.SelectedIndex = 0;
ddlTitle.SelectedIndex = 0;
ddlTransactionType.SelectedIndex = 0;
ddlConsultedDoctor.SelectedIndex = 0;
txtCharge.Text = "";
txtSum.Text = "";
txtVideNo.Text = "";
txtDrawnOn.Text = "";
txtDated.Text = "";
txtRemarks.Text = "";
}
protected void cmdAddItem_Click(object sender, EventArgs e)
{
gvGeneralCollection.Visible = true;
try
{
if (ddlTransactionType.SelectedIndex != 0)
{
gvGeneralCollection.Visible = true;
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
string strSQL1 = " INSERT INTO [tmpTransList](THID,TransName,Charge)VALUES('" + txtReceiptNo.Text + "','" + ddlTransactionType.SelectedItem.ToString() + "','" + txtCharge.Text + "')";
SqlCommand cmd1 = new SqlCommand(strSQL1, sqlConn);
cmd1.ExecuteNonQuery();
SqlDataAdapter dadapter = new SqlDataAdapter(" SELECT THID,TransName,Charge from tmpTransList", sqlConn);
DataSet dset = new DataSet();
dadapter.Fill(dset);
gvGeneralCollection.DataSource = dset;
gvGeneralCollection.DataBind();
sqlConn.Close();
ddlTransactionType.SelectedIndex = 0;
txtCharge.Text = "";
}
else
{
Response.Write("");
}
}
catch (Exception)
{
Response.Write("");
}
}
protected void rbIP_CheckedChanged(object sender, EventArgs e)
{
if (rbIP.Checked == true)
{
PatientType = "IP";
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
string strSQL = "Select MAX(RegID) from registration_details ";
SqlCommand cmdRegistration = new SqlCommand(strSQL, sqlConn);
object No = cmdRegistration.ExecuteScalar();
if (No == DBNull.Value)
{
txtHospitalNo.Text = "CMC1";
}
else
{
int m = Convert.ToInt32(No.ToString());
int n = m + 1;
txtHospitalNo.Text = "CMC" + n.ToString();
}
}
}
protected void rbOP_CheckedChanged(object sender, EventArgs e)
{
if (rbOP.Checked == true)
{
PatientType = "OP";
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
string strSQL = "Select MAX(RegID) from registration_details ";
SqlCommand cmdRegistration = new SqlCommand(strSQL, sqlConn);
object No = cmdRegistration.ExecuteScalar();
if (No == DBNull.Value)
{
txtHospitalNo.Text = "CMC1";
}
else
{
int m = Convert.ToInt32(No.ToString());
int n = m + 1;
txtHospitalNo.Text = "CMC" + n.ToString();
}
}
}
protected void rbDirect_CheckedChanged(object sender, EventArgs e)
{
if (rbDirect.Checked == true)
{
PatientType = "Direct";
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
string strSQL = "Select MAX(RegID) from registration_details ";
SqlCommand cmdRegistration = new SqlCommand(strSQL, sqlConn);
object No = cmdRegistration.ExecuteScalar();
if (No == DBNull.Value)
{
txtHospitalNo.Text = "RF1";
}
else
{
int m = Convert.ToInt32(No.ToString());
int n = m + 1;
txtHospitalNo.Text = "RF" + n.ToString();
}
}
}
protected void Save_Record()
{
try
{
if (validate_data())
{
string DocId = DoctorID(ddlConsultedDoctor.SelectedValue);
string PId = PatientCode(ddlPatientName.SelectedValue);
string User = Request.QueryString["txtuser"];
string Computer = System.Environment.MachineName;
string strSQL;
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
strSQL = "INSERT INTO [COLLECTION_TRANS](ReceiptNo,ReceiptDate,DoctorID,HospitalNo,Charge,UserLogged,DateCreated)VALUES ('" + txtReceiptNo.Text + "','" + txtDate.Text + "','" + DocId + "','" + txtHospitalNo.Text + "','" + txtSum.Text + "','" + User + "','" + System.DateTime.Now.ToString("dd/MM/yyyy") + "')";
SqlCommand cmdCollection = new SqlCommand(strSQL, sqlConn);
cmdCollection.ExecuteNonQuery();
// string strSQL1 = "INSERT INTO [payment_details](Receipt_Number,Receipt_Date,HospitalNo,Patient_ID,Amount,Payment_Type,Cheque_No,Cheque_Date,Banker,DateCreated,Remarks)VALUES ('" + txtReceiptNo.Text + "','" + txtDate.Text + "','" + txtHospitalNo.Text + "','" + PId + "','" + txtSum.Text + "','" + PaymentType + "','" + txtVideNo.Text + "','" + txtDated.Text + "','" + txtDrawnOn.Text + "','" + System.DateTime.Now.ToString("dd/MM/yyyy") + "','" + txtRemarks.Text + "')";
//string strSQL1 = "INSERT INTO [payment_details](Receipt_Number,Receipt_Date,HospitalNo,Patient_ID,Amount,Payment_Type,Cheque_No,ComputerName,Banker,DateCreated,Remarks,Cheque_Date)VALUES ('" + txtReceiptNo.Text + "','" + txtDate.Text + "','" + txtHospitalNo.Text + "','" + PId + "','" + txtSum.Text + "','" + PaymentType + "','" + txtVideNo.Text + "','" + Computer + "','" + txtDrawnOn.Text + "','" + System.DateTime.Now.ToString("dd/MM/yyyy") + "','" + txtRemarks.Text + "','"+txtDated.Text+"')";
//SqlCommand cmdPaymentDetails = new SqlCommand(strSQL1, sqlConn);
//cmdPaymentDetails.ExecuteNonQuery();
//sqlConn.Close();
Response.Write("");
Load_Record();
}
}
catch (Exception)
{
Response.Write("");
}
}
protected void Delete_Record()
{
string strSQL;
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
strSQL = "Delete [COLLECTION_TRANS] Where ReceiptNo ='"+txtReceiptNo.Text+"'";
SqlCommand cmdWardDetails = new SqlCommand(strSQL, sqlConn);
cmdWardDetails.ExecuteNonQuery();
sqlConn.Close();
Response.Write("");
Load_Record();
// Record_Count();
}
protected void Load_Record()
{
SqlCollection.SelectCommand = " SELECT COLLECTION_TRANS.ReceiptNo, COLLECTION_TRANS.ReceiptDate, COLLECTION_TRANS.TransType, COLLECTION_TRANS.DoctorID,COLLECTION_TRANS.HospitalNo, COLLECTION_TRANS.DateCreated, payment_details.Amount, payment_details.Payment_Type,payment_details.Cheque_No, payment_details.Cheque_Date, payment_details.Banker, payment_details.Patient_ID, payment_details.Remarks,payment_details.DateCreated AS Expr1 FROM COLLECTION_TRANS CROSS JOIN payment_details";
SqlCollection.SelectCommand="SELECT COLLECTION_TRANS.ReceiptNo, COLLECTION_TRANS.ReceiptDate, COLLECTION_TRANS.DoctorID, COLLECTION_TRANS.Charge,payment_details.Patient_ID, payment_details.Payment_Type, payment_details.Amount, payment_details.Cheque_No, payment_details.Cheque_Date,payment_details.Banker, payment_details.DateCreated, payment_details.Remarks FROM COLLECTION_TRANS INNER JOIN payment_details ON COLLECTION_TRANS.HospitalNo = payment_details.HospitalNo";
}
protected void Update_Record()
{
try
{
string strSQL;
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
strSQL = "Update [COLLECTION_TRANS] Set ReceiptDate='" + txtDate.Text + "',TransType='" + ddlTransactionType.SelectedItem.ToString() + "',HospitalNo='" + txtHospitalNo.Text + "' ,Charge='" + txtCharge.Text + "' Where ReceiptNo ='" +txtReceiptNo.Text+ "'";
SqlCommand cmdWardDetails = new SqlCommand(strSQL, sqlConn);
cmdWardDetails.ExecuteNonQuery();
sqlConn.Close();
Response.Write("");
Load_Record();
}
catch (Exception)
{
Response.Write("");
}
}
protected bool validate_data()
{
// string strSQL;
// string strName;
// strName = "";
// string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
// SqlConnection sqlConn = new SqlConnection(dbConn);
// sqlConn.Open();
//// strSQL = "Select ReceiptDate,TransType,DoctorID,HospitalNo,Charge from [COLLECTION_TRANS] Where ReceiptNo='" + txtReceiptNo.Text + "'";
// strSQL = "SELECT COLLECTION_TRANS.ReceiptNo, COLLECTION_TRANS.ReceiptDate, COLLECTION_TRANS.DoctorID, COLLECTION_TRANS.Charge,payment_details.Patient_ID, payment_details.Payment_Type, payment_details.Amount, payment_details.Cheque_No, payment_details.Cheque_Date,payment_details.Banker, payment_details.DateCreated, payment_details.Remarks FROM COLLECTION_TRANS INNER JOIN payment_details ON COLLECTION_TRANS.HospitalNo = payment_details.HospitalNo";
// SqlCommand cmdWardDetails = new SqlCommand(strSQL, sqlConn);
// SqlDataReader drWard = cmdWardDetails.ExecuteReader();
// while (drWard.Read())
// {
// strName = drWard[0].ToString();
// }
// sqlConn.Close();
// if (strName != "")
// {
// Response.Write("");
// return false;
// }
// if (txtDate.Text== "")
// {
// Response.Write("");
// return false;
// }
// if (txtHospitalNo.Text == "")
// {
// Response.Write("");
// return false;
// }
return true;
}
protected void Display_Record(string strCode)
{
string strSQL;
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
// strSQL = "Select ReceiptDate,TransType,DoctorID,HospitalNo,Charge from [COLLECTION_TRANS] where ReceiptNo='" +txtReceiptNo.Text+ "' ";
strSQL = "SELECT COLLECTION_TRANS.ReceiptNo, COLLECTION_TRANS.ReceiptDate, COLLECTION_TRANS.DoctorID, COLLECTION_TRANS.Charge,payment_details.Patient_ID, payment_details.Payment_Type, payment_details.Amount, payment_details.Cheque_No, payment_details.Cheque_Date,payment_details.Banker, payment_details.DateCreated, payment_details.Remarks FROM COLLECTION_TRANS INNER JOIN payment_details ON COLLECTION_TRANS.HospitalNo = payment_details.HospitalNo";
SqlCommand cmdWardDetails = new SqlCommand(strSQL, sqlConn);
SqlDataReader drWardDetails = cmdWardDetails.ExecuteReader();
while (drWardDetails.Read())
{
txtReceiptNo.Text= drWardDetails[0].ToString();
txtDate.Text= drWardDetails[1].ToString();
ddlConsultedDoctor.SelectedItem.Text = drWardDetails[2].ToString();
txtSum.Text = drWardDetails[3].ToString();
ddlPatientName.SelectedItem.Text = drWardDetails[4].ToString();
}
sqlConn.Close();
}
protected void cmdAdd_Click(object sender, EventArgs e)
{
string strAdd;
strAdd = cmdAdd.Text;
if (strAdd == "ADD")
{
ClearFields();
ReceiptNo();
string DocId = DoctorID(ddlConsultedDoctor.SelectedValue);
txtDate.Text = System.DateTime.Now.ToString("dd-MM-yyyy");
cmdAdd.Text = "SAVE";
txtReceiptNo.Enabled = true;
txtDate.Enabled = true;
txtHospitalNo.Enabled = true;
ddlVisitType.Enabled = true;
ddlPatientName.Enabled = true;
ddlTitle.Enabled = true;
ddlTransactionType.Enabled = true;
txtCharge.Enabled = true;
txtSum.Enabled = true;
txtVideNo.Enabled = true;
ddlConsultedDoctor.Enabled = true;
txtDrawnOn.Enabled = true;
txtDated.Enabled = true;
txtRemarks.Enabled = true;
cmdDelete.Enabled = false;
cmdModify.Enabled = false;
}
else if (strAdd == "SAVE")
{
if (txtReceiptNo.Text == "" || txtDate.Text == "" || txtHospitalNo.Text == "" || ddlPatientName.SelectedItem.Text == "" || txtSum.Text == "")
{
Response.Write("");
}
else
{
Save_Record();
}
cmdAdd.Text = "ADD";
ClearFields();
cmdDelete.Enabled = false;
cmdModify.Enabled = false;
txtReceiptNo.Enabled = false;
txtDate.Enabled = false;
txtHospitalNo.Enabled = false;
ddlVisitType.Enabled = false;
ddlPatientName.Enabled = false;
ddlTitle.Enabled = false;
ddlTransactionType.Enabled = false;
txtCharge.Enabled = false;
txtSum.Enabled = false;
txtVideNo.Enabled = false;
ddlConsultedDoctor.Enabled = false;
txtDrawnOn.Enabled = false;
txtDated.Enabled = false;
txtRemarks.Enabled = false;
}
}
protected void cmdModify_Click(object sender, EventArgs e)
{
string strAdd;
strAdd = cmdModify.Text;
if (strAdd == "MODIFY")
{
txtReceiptNo.Enabled = false;
txtDate.Enabled = false;
txtHospitalNo.Enabled = false;
ddlVisitType.Enabled = false;
ddlPatientName.Enabled = false;
ddlTitle.Enabled = false;
ddlTransactionType.Enabled = false;
txtCharge.Enabled = false;
txtSum.Enabled = false;
txtVideNo.Enabled = false;
ddlConsultedDoctor.Enabled = false;
txtDrawnOn.Enabled = false;
txtDated.Enabled = false;
txtRemarks.Enabled = false;
cmdModify.Text = "UPDATE";
cmdDelete.Enabled = false;
cmdAdd.Enabled = false;
}
else if (strAdd == "UPDATE")
{
if (txtReceiptNo.Text == "" || txtDate.Text == "" || txtHospitalNo.Text == "" || ddlPatientName.SelectedItem.Text == "" || txtSum.Text == "")
{
Response.Write("");
}
else
{
Update_Record();
}
cmdModify.Text = "MODIFY";
ClearFields();
cmdModify.Enabled = false;
cmdDelete.Enabled = false;
cmdAdd.Enabled = true;
txtReceiptNo.Enabled = false;
txtDate.Enabled = false;
txtHospitalNo.Enabled = false;
ddlVisitType.Enabled = false;
ddlPatientName.Enabled = false;
ddlTitle.Enabled = false;
ddlTransactionType.Enabled = false;
txtCharge.Enabled = false;
txtSum.Enabled = false;
txtVideNo.Enabled = false;
ddlConsultedDoctor.Enabled = false;
txtDrawnOn.Enabled = false;
txtDated.Enabled = false;
txtRemarks.Enabled = false;
}
}
protected void cmdDelete_Click(object sender, EventArgs e)
{
if (txtReceiptNo.Text== "")
{
Response.Write("");
}
else
{
Delete_Record();
}
}
protected void cmdCancel_Click(object sender, EventArgs e)
{
cmdAdd.Text = "ADD";
cmdModify.Text = "MODIFY";
gvGeneralCollection.Visible = false;
ClearFields();
Grid_clear();
txtReceiptNo.Enabled = false;
txtDate.Enabled = false;
txtHospitalNo.Enabled = false;
ddlVisitType.Enabled = false;
ddlPatientName.Enabled = false;
ddlTitle.Enabled = false;
ddlTransactionType.Enabled = false;
txtCharge.Enabled = false;
txtSum.Enabled = false;
txtVideNo.Enabled = false;
ddlConsultedDoctor.Enabled = false;
txtDrawnOn.Enabled = false;
txtDated.Enabled = false;
txtRemarks.Enabled = false;
cmdAdd.Enabled = true;
cmdModify.Enabled = false;
cmdDelete.Enabled = false;
Grid_clear();
}
protected void Grid_clear()
{
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
string strSQL;
strSQL = "Delete from tmpTransList ";
SqlCommand cmdPoOreder = new SqlCommand(strSQL, sqlConn);
cmdPoOreder.ExecuteNonQuery();
sqlConn.Close();
}
protected void BindGrid()
{
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
SqlDataAdapter ItemIssueAdapter = new SqlDataAdapter("Select * from tmpTransList", sqlConn);
DataSet datasetItemIssues = new DataSet();
ItemIssueAdapter.Fill(datasetItemIssues);
gvGeneralCollection.DataSource = datasetItemIssues.Tables[0];
gvGeneralCollection.DataBind();
}
protected void gvGeneralCollection_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
string TransName = gvGeneralCollection.DataKeys[e.RowIndex].Values[0].ToString();
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
SqlDataAdapter da = new SqlDataAdapter("", sqlConn);
da.DeleteCommand = new SqlCommand("delete from tmpTransList where TransName='" + TransName + "'", sqlConn);
da.DeleteCommand.ExecuteNonQuery();
BindGrid();
sqlConn.Close();
}
catch (Exception)
{
Response.Write("");
}
}
protected void gvGeneralCollection_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
if (e.Row.RowType == DataControlRowType.EmptyDataRow)
{
grdAmount = 0;
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
decimal TotalAmount = Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Charge"));
grdAmount = grdAmount + TotalAmount;
}
if (e.Row.RowType == DataControlRowType.Footer)
{
Label lb4 = (Label)e.Row.FindControl("lbltotalAmount");
lb4.Text = grdAmount.ToString();
txtSum.Text= grdAmount.ToString();
}
}
catch (Exception)
{
// Response.Write("");
}
}
protected void rbCash_CheckedChanged(object sender, EventArgs e)
{
if (rbCash.Checked == true)
{
PaymentType= "Cash";
}
}
protected void rbCheque_CheckedChanged(object sender, EventArgs e)
{
PaymentType = "Cheque";
}
protected void rbDD_CheckedChanged(object sender, EventArgs e)
{
PaymentType = "DD";
}
protected void rbCreditCard_CheckedChanged(object sender, EventArgs e)
{
PaymentType = "Credit Card";
}
protected void rbDebitCard_CheckedChanged(object sender, EventArgs e)
{
PaymentType = "Debit Card";
}
protected void rbAmountCollectLater_CheckedChanged(object sender, EventArgs e)
{
PaymentType = "Amount Collect Later";
}
protected void ddlTitle_SelectedIndexChanged(object sender, EventArgs e)
{
//ddlPatientName.Items.Clear();
//string strSQL;
//string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
//SqlConnection sqlConn = new SqlConnection(dbConn);
//sqlConn.Open();
//strSQL = "select Patient_Name from registration_details where Title='"+ddlTitle.SelectedItem.ToString()+"'";
//SqlCommand cmdPatientName = new SqlCommand(strSQL, sqlConn);
//ddlPatientName.Items.Add("<============Select==========>");
//SqlDataReader drPatientName = cmdPatientName.ExecuteReader();
//while (drPatientName.Read())
//{
// ddlPatientName.Items.Add(drPatientName[0].ToString());
//}
//sqlConn.Close();
}
protected void gvCollection_DataBound(object sender, EventArgs e)
{
lblPage.Text = string.Format("You are viewing page {0} of {1}", gvCollection.PageIndex + 1, gvCollection.PageCount);
ddlPageList.Items.Clear();
for (int i = 0; i < gvCollection.PageCount; i++)
{
ListItem pageListItem = new ListItem(string.Concat(i + 1), i.ToString());
ddlPageList.Items.Add(pageListItem);
if (gvCollection.Rows.Count > 0)
{
lblSearchRecords.Text = "Results found " + gvCollection.Rows.Count.ToString() + "Records";
}
if (i == gvCollection.PageIndex)
{
pageListItem.Selected = true;
}
}
}
public string HighlightText(string InputTxt)
{
string Search_Str = TxtSearch.Text;
Regex RegExp = new Regex(Search_Str.Replace(" ", "|").Trim(), RegexOptions.IgnoreCase);
return RegExp.Replace(InputTxt, new MatchEvaluator(ReplaceKeyWords));
}
public static string ReplaceKeyWords(Match m)
{
return ("" + m.Value + "");
}
protected void gvCollection_PreRender(object sender, EventArgs e)
{
GridView gv = (GridView)sender;
GridViewRow gvr = (GridViewRow)gv.TopPagerRow;
if (gvr != null)
{
gvr.Visible = true;
}
}
protected void gvCollection_RowCommand(object sender, GridViewCommandEventArgs e)
{
}
protected void gvCollection_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void CmdSearch_Click(object sender, EventArgs e)
{
SearchString = TxtSearch.Text;
lblSearchRecords.Visible = true;
if (TxtSearch.Text == "")
{
lblSearchRecords.Text = "Enter Keyword to search by ";
lblSearchRecords.Visible = true;
}
else
{
lblSearchRecords.Text = "Results found " + gvCollection.Rows.Count.ToString() + "Records";
lblSearchRecords.Visible = true;
}
}
protected void CmdClear_Click(object sender, EventArgs e)
{
lblSearchRecords.Visible = false;
TxtSearch.Text = "";
SearchString = "";
gvCollection.DataBind();
}
protected void ddlPageList_SelectedIndexChanged(object sender, EventArgs e)
{
gvCollection.PageIndex = Convert.ToInt32(ddlPageList.SelectedValue);
}
Now i want to select Sex and Payment Type Radio button Based on gridview selected row.
Anyone help me please...........Its urgent..
Thanks in advance..................
Replies
Know the answer? Post it — somebody with the same question will find it here.