protected void btnAdd_Click(object sender, EventArgs e)
{
Conv_Registration conv_Registration = new Conv_Registration();
conv_Registration.Conv_ConventionID = Int32.Parse(txtConv_ConventionID.Text);
conv_Registration.Mem_MemberID = Int32.Parse(txtMem_Member.Text);
conv_Registration.RegistrationFee = Int32.Parse(txtRegistrationFee.Text);
conv_Registration.Lunch1No = Int32.Parse(txtLunch1No.Text);
conv_Registration.Lunch1Amount = Int32.Parse(txtLunch1Amount.Text);
conv_Registration.Lunch2No = Int32.Parse(txtLunch2No.Text);
conv_Registration.Lunch2Amount = Int32.Parse(txtLunch2Amount.Text);
conv_Registration.Dinner1 = Int32.Parse(txtDinner1.Text);
conv_Registration.Dinner2 = Int32.Parse(txtDinner2.Text);
conv_Registration.LadiesBag = Int32.Parse(txtLadiesBag.Text);
conv_Registration.IEBTie = Int32.Parse(txtIEBTie.Text);
conv_Registration.TotalIEBFee = Int32.Parse(txtTotalIEBFee.Text);
conv_Registration.BKashFees = Int32.Parse(txtBKashFees.Text);
conv_Registration.TotalPayable = Int32.Parse(txtTotalPayable.Text);
conv_Registration.TrxID = txtTrx.Text;
conv_Registration.AddedDate = DateTime.Now;
conv_Registration.TypeID = Int32.Parse(txtType.Text);
conv_Registration.StatusID = Int32.Parse(txtStatus.Text);
conv_Registration.ExtraField1 = txtExtraField1.Text;
conv_Registration.ExtraField2 = txtExtraField2.Text;
conv_Registration.ExtraField3 = txtExtraField3.Text;
conv_Registration.ExtraField4 = txtExtraField4.Text;
conv_Registration.ExtraField5 = txtExtraField5.Text;
int resutl = Conv_RegistrationManager.InsertConv_Registration(conv_Registration);
Response.Redirect("AdminConv_RegistrationDisplayAdmin.aspx");
}
private void showConv_RegistrationData()
{
Conv_Registration conv_Registration = new Conv_Registration();
conv_Registration = Conv_RegistrationManager.GetConv_RegistrationByID(Int32.Parse(Request.QueryString["conv_RegistrationID"]));
txtConv_ConventionID.Text = conv_Registration.Conv_ConventionID.ToString();
txtMem_Member.Text = conv_Registration.Mem_MemberID.ToString();
txtRegistrationFee.Text = conv_Registration.RegistrationFee.ToString();
txtLunch1No.Text = conv_Registration.Lunch1No.ToString();
txtLunch1Amount.Text = conv_Registration.Lunch1Amount.ToString();
txtLunch2No.Text = conv_Registration.Lunch2No.ToString();
txtLunch2Amount.Text = conv_Registration.Lunch2Amount.ToString();
txtDinner1.Text = conv_Registration.Dinner1.ToString();
txtDinner2.Text = conv_Registration.Dinner2.ToString();
txtLadiesBag.Text = conv_Registration.LadiesBag.ToString();
txtIEBTie.Text = conv_Registration.IEBTie.ToString();
txtTotalIEBFee.Text = conv_Registration.TotalIEBFee.ToString();
txtBKashFees.Text = conv_Registration.BKashFees.ToString();
txtTotalPayable.Text = conv_Registration.TotalPayable.ToString();
txtTrx.Text = conv_Registration.TrxID.ToString();
txtType.Text = conv_Registration.TypeID.ToString();
txtStatus.Text = conv_Registration.StatusID.ToString();
//txtExtraField1.Text = conv_Registration.ExtraField1;
//txtExtraField2.Text = conv_Registration.ExtraField2;
txtExtraField3.Text = conv_Registration.ExtraField3;
txtExtraField4.Text = conv_Registration.ExtraField4;
txtExtraField5.Text = conv_Registration.ExtraField5;
}
protected void lbDelete_Click(object sender, EventArgs e)
{
LinkButton linkButton = new LinkButton();
linkButton = (LinkButton)sender;
bool result = Conv_RegistrationManager.DeleteConv_Registration(Convert.ToInt32(linkButton.CommandArgument));
showConv_RegistrationGrid();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Conv_Registration tempConv_Registration = new Conv_Registration();
tempConv_Registration = Conv_RegistrationManager.GetConv_RegistrationByID(Int32.Parse(Request.QueryString["conv_RegistrationID"]));
Conv_Registration conv_Registration = new Conv_Registration();
conv_Registration.Conv_RegistrationID = tempConv_Registration.Conv_RegistrationID;
conv_Registration.Conv_ConventionID = Int32.Parse(txtConv_ConventionID.Text);
conv_Registration.Mem_MemberID = Int32.Parse(txtMem_Member.Text);
conv_Registration.RegistrationFee = Int32.Parse(txtRegistrationFee.Text);
conv_Registration.Lunch1No = Int32.Parse(txtLunch1No.Text);
conv_Registration.Lunch1Amount = Int32.Parse(txtLunch1Amount.Text);
conv_Registration.Lunch2No = Int32.Parse(txtLunch2No.Text);
conv_Registration.Lunch2Amount = Int32.Parse(txtLunch2Amount.Text);
conv_Registration.Dinner1 = Int32.Parse(txtDinner1.Text);
conv_Registration.Dinner2 = Int32.Parse(txtDinner2.Text);
conv_Registration.LadiesBag = Int32.Parse(txtLadiesBag.Text);
conv_Registration.IEBTie = Int32.Parse(txtIEBTie.Text);
conv_Registration.TotalIEBFee = Int32.Parse(txtTotalIEBFee.Text);
conv_Registration.BKashFees = Int32.Parse(txtBKashFees.Text);
conv_Registration.TotalPayable = Int32.Parse(txtTotalPayable.Text);
conv_Registration.TrxID = txtTrx.Text;
conv_Registration.AddedDate = tempConv_Registration.AddedDate;
conv_Registration.TypeID = Int32.Parse(txtType.Text);
conv_Registration.StatusID = Int32.Parse(txtStatus.Text);
conv_Registration.ExtraField1 = "";// tempConv_Registration.ExtraField1;
if (tempConv_Registration.ExtraField2 != "")
{
conv_Registration.ExtraField2 = tempConv_Registration.ExtraField2.Replace("EnterTrxID", conv_Registration.TrxID);
}
else
{
conv_Registration.ExtraField2 = tempConv_Registration.ExtraField1.Replace(
@"<tr>
<td style='border:1px solid black; text-align:left;' colspan='3'>Please write down here the Transaction ID(TraxID) which you will receive from bKash by SMS</td>
<td style='border:1px solid black;' colspan='2'> </td>
</tr>",
"<td style='border:1px solid black; text-align:right;' colspan='3'>Transaction ID(TrxID)</td> <td style='border:1px solid black;' colspan='2'>" + txtTrx.Text + "</td>").Replace(
"<img src='http://iebbd.org/images/Convention/55/formHeader.png' width='400px'/>",
"<img src='http://iebbd.org/images/Convention/55/formHeader.png' width='400px'/><br/>Money Receipt");
}
conv_Registration.ExtraField3 = txtExtraField3.Text;
conv_Registration.ExtraField4 = txtExtraField4.Text;
conv_Registration.ExtraField5 = txtExtraField5.Text;
bool result = Conv_RegistrationManager.UpdateConv_Registration(conv_Registration);
Response.Redirect("AdminConv_RegistrationDisplayAdmin.aspx");
}
private void showConv_RegistrationGrid()
{
List <Conv_Registration> conventionRegistrations = new List <Conv_Registration>();
conventionRegistrations = Conv_RegistrationManager.GetAllConv_Registrations();
foreach (Conv_Registration item in conventionRegistrations)
{
item.ExtraField5 = "../MembersArea/ConventionPaymentPrint.aspx?Conv_RegistrationID=710307" + item.Conv_RegistrationID + "034438";
item.ExtraField3 = "../MembersArea/ConventionPaymentPrint.aspx?Confirmation=1&Conv_RegistrationID=710307" + item.Conv_RegistrationID + "034438";
}
gvConv_Registration.DataSource = conventionRegistrations;
gvConv_Registration.DataBind();
}
private void showConv_RegistrationGrid()
{
List <Conv_Registration> conventionRegistrations = new List <Conv_Registration>();
if (rbtnlPyament.SelectedValue == "3")
{
conventionRegistrations = Conv_RegistrationManager.GetAllConv_Registrations();
foreach (Conv_Registration item in conventionRegistrations)
{
item.ExtraField5 = "../MembersArea/ConventionPaymentPrint.aspx?Conv_RegistrationID=710307" + item.Conv_RegistrationID + "034438";
}
gvConv_Registration.DataSource = conventionRegistrations;
}
else if (rbtnlPyament.SelectedValue == "2")
{
string sql = @"
Declare @IsFalse bit
Declare @IsTrue bit
set @IsFalse=0
set @IsTrue=1
SELECT [Conv_Registration].[Conv_RegistrationID]
,[Conv_Registration].[Conv_ConventionID]
,[Conv_Registration].[Mem_MemberID]
,[Conv_Registration].[RegistrationFee]
,[Conv_Registration].[Lunch1No]
,[Conv_Registration].[Lunch1Amount]
,[Conv_Registration].[Lunch2No]
,[Conv_Registration].[Lunch2Amount]
,[Conv_Registration].[Dinner1]
,[Conv_Registration].[Dinner2]
,[Conv_Registration].[LadiesBag]
,[Conv_Registration].[IEBTie]
,[Conv_Registration].[TotalIEBFee]
,[Conv_Registration].[bKashFees]
,[Conv_Registration].[TotalPayable]
,[Conv_Registration].[TrxID]
,[Conv_Registration].[AddedDate]
,[Conv_Registration].[TypeID]
,[Conv_Registration].[StatusID]
,[Conv_Registration].[ExtraField1]
,[Conv_Registration].[ExtraField2]
,[Conv_Registration].[ExtraField3]
,Mem_Member.MemberShipNo as [ExtraField4]
,[Conv_Registration].[ExtraField5]
FROM [Conv_Registration]
inner join Mem_Member on Mem_Member.Mem_MemberID = Conv_Registration.Mem_MemberID
where TrxID='' and StatusID<>3
order by [Conv_Registration].AddedDate desc
";
DataSet ds = DatabaseManager.ExecSQL(sql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
dr["ExtraField5"] = "../MembersArea/ConventionPaymentPrint.aspx?Conv_RegistrationID=710307" + dr["Conv_RegistrationID"].ToString() + "034438";
}
gvConv_Registration.DataSource = ds.Tables[0];
//conventionRegistrations = Conv_RegistrationManager.GetAllConv_Registrations().FindAll(x => x.TrxID == "");
}
else if (rbtnlPyament.SelectedValue == "1")
{
string sql = @"
Declare @IsFalse bit
Declare @IsTrue bit
set @IsFalse=0
set @IsTrue=1
SELECT [Conv_Registration].[Conv_RegistrationID]
,[Conv_Registration].[Conv_ConventionID]
,[Conv_Registration].[Mem_MemberID]
,[Conv_Registration].[RegistrationFee]
,[Conv_Registration].[Lunch1No]
,Lunch1E=(CASE [Conv_Registration].[Lunch1No] WHEN 0 THEN @IsFalse ELSE @IsTrue END)
,[Conv_Registration].[Lunch1Amount]
,[Conv_Registration].[Lunch2No]
,Lunch2E=(CASE [Conv_Registration].[Lunch2No] WHEN 0 THEN @IsFalse ELSE @IsTrue END)
,[Conv_Registration].[Lunch2Amount]
,[Conv_Registration].[Dinner1]/500 as Dinner1
,Dinner1E=(CASE ([Conv_Registration].[Dinner1]/500) WHEN 0 THEN @IsFalse ELSE @IsTrue END)
,[Conv_Registration].[Dinner2]/800 as Dinner2
,Dinner2E=(CASE ([Conv_Registration].[Dinner2]/500) WHEN 0 THEN @IsFalse ELSE @IsTrue END)
,[Conv_Registration].[LadiesBag]/1200 as LadiesBag
,LadiesBagE=(CASE ([Conv_Registration].[LadiesBag]/500) WHEN 0 THEN @IsFalse ELSE @IsTrue END)
,[Conv_Registration].[IEBTie]/500 as IEBTie
,IEBTieE=(CASE ([Conv_Registration].[IEBTie]/500) WHEN 0 THEN @IsFalse ELSE @IsTrue END)
,[Conv_Registration].[TotalIEBFee]
,[Conv_Registration].[bKashFees]
,[Conv_Registration].[TotalPayable]
,[Conv_Registration].[TrxID]
,[Conv_Registration].[AddedDate]
,[Conv_Registration].[TypeID]
,[Conv_Registration].[StatusID]
,[Conv_Registration].[ExtraField1]
,[Conv_Registration].[ExtraField2]
,[Conv_Registration].[ExtraField3]
,Mem_Member.MemberShipNo as [ExtraField4]
,[Conv_Registration].[ExtraField5]
,'' as PictureUrl
FROM [Conv_Registration]
inner join Mem_Member on Mem_Member.Mem_MemberID = Conv_Registration.Mem_MemberID
where TrxID <>'' and StatusID<>3 and Mem_Member.Mem_MemberID=" + Request.QueryString["Mem_MemberID"] + @"
order by [Conv_Registration].AddedDate desc ";
DataSet ds = DatabaseManager.ExecSQL(sql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
dr["ExtraField5"] = "../MembersArea/ConventionPaymentPrint.aspx?Conv_RegistrationID=710307" + dr["Conv_RegistrationID"].ToString() + "034438";
dr["PictureUrl"] = "../MembersArea/MemberPicture/" + dr["ExtraField4"].ToString().Split('/')[0] + "-" + dr["ExtraField4"].ToString().Split('/')[1] + ".jpg";
}
gvConv_Registration.DataSource = ds.Tables[0];
}
gvConv_Registration.DataBind();
}
protected void btnConventionFee_Click(object sender, EventArgs e)
{
string sql = "";
foreach (GridViewRow gvr in gvbKash.Rows)
{
try
{
TextBox txtCorrctReferenceNo = (TextBox)gvr.FindControl("txtCorrctReferenceNo");
TextBox txtMemberShipNo = (TextBox)gvr.FindControl("txtMemberShipNo");
Label lblTransactionID = (Label)gvr.FindControl("lblTransactionID");
Label lblAmount = (Label)gvr.FindControl("lblAmount");
Label lblTrancsactionTime = (Label)gvr.FindControl("lblTrancsactionTime");
Label lblMobile = (Label)gvr.FindControl("lblMobile");
Label lblEmail = (Label)gvr.FindControl("lblEmail");
CheckBox chkSelect = (CheckBox)gvr.FindControl("chkSelect");
RadioButtonList rbtnPaidUpto = (RadioButtonList)gvr.FindControl("rbtnPaidUpto");
if (chkSelect.Checked && txtMemberShipNo.Text.Trim() != "")
{
sql = @"
update Acc_bKash_Final set ExtraField1=(Select cast(Mem_MemberID as nvarchar) from Mem_Member where MemberShipNo ='" + txtMemberShipNo.Text + @"') where TransactionID=" + lblTransactionID.Text + @"
SELECT Conv_RegistrationID
FROM [Conv_Registration]
where Mem_MemberID =(Select Mem_MemberID from Mem_Member where MemberShipNo='" + txtMemberShipNo.Text + @"')
";
DataSet dstmp = DatabaseManager.ExecSQL(sql);
Conv_Registration tempConv_Registration = new Conv_Registration();
tempConv_Registration = Conv_RegistrationManager.GetConv_RegistrationByID(Int32.Parse(dstmp.Tables[0].Rows[0][0].ToString()));
if (tempConv_Registration.ExtraField2 != "")
{
if (!tempConv_Registration.TrxID.Contains(lblTransactionID.Text))
{
tempConv_Registration.TrxID += (tempConv_Registration.TrxID.Trim() == "" ? "" : ", ") + lblTransactionID.Text;
}
if (tempConv_Registration.ExtraField2.Contains("Money Receipt"))
{
tempConv_Registration.ExtraField2 = tempConv_Registration.ExtraField2.Replace("EnterTrxID", lblTransactionID.Text);
}
Conv_RegistrationManager.UpdateConv_Registration(tempConv_Registration);
}
else if (!tempConv_Registration.ExtraField2.Contains("Transaction ID(TrxID)</td>"))
{
if (!tempConv_Registration.TrxID.Contains(lblTransactionID.Text))
{
tempConv_Registration.TrxID += (tempConv_Registration.TrxID.Trim() == "" ? "" : ", ") + lblTransactionID.Text;
}
if (!tempConv_Registration.ExtraField2.Contains("Money Receipt"))
{
tempConv_Registration.ExtraField2 = tempConv_Registration.ExtraField1.Replace(
@"<tr>
<td style='border:1px solid black; text-align:left;' colspan='3'>Please write down here the Transaction ID(TraxID) which you will receive from bKash by SMS</td>
<td style='border:1px solid black;' colspan='2'> </td>
</tr>",
"<td style='border:1px solid black; text-align:right;' colspan='3'>Transaction ID(TrxID)</td> <td style='border:1px solid black;' colspan='2'>" + lblTransactionID.Text + "</td>").Replace(
"<img src='http://iebbd.org/images/Convention/55/formHeader.png' width='400px'/>",
"<img src='http://iebbd.org/images/Convention/55/formHeader.png' width='400px'/><br/>Money Receipt");
}
Conv_RegistrationManager.UpdateConv_Registration(tempConv_Registration);
}
//SMS
if (lblMobile.Text.Trim() != "")
{
try
{
string SMS = "Thanks for bKash payment to IEB.Your registration for Convention 55 is Confirmed. Your payment amount(" + lblAmount.Text + ") and trxID: " + lblTransactionID.Text;
MyWebRequest myRequest = new MyWebRequest("http://cbsms.grameenphone.com/send_sms_api/send_sms_from_api.php?user_name=IEBadmin&password=IEBadmin123&subscriber_no=" + lblMobile.Text.Trim().Substring(1, 10) + "&mask=IEB&sms=" + SMS);
//MyWebRequest myRequest = new MyWebRequest("http://cbsms.grameenphone.com/send_sms_api/send_sms_from_api.php?user_name=IEBadmin&password=IEBadmin123&subscriber_no=1818619647&mask=IEB&sms=" + SMS);
XmlDocument doc = new XmlDocument();
//doc.LoadXml(myRequest.GetResponse());
}
catch (Exception ex)
{ }
}
//Mail
if (lblEmail.Text.Trim() != "")
{
try
{
string mialMessage = "Dear Engr,<br/><br/>Thanks for bKash payment.Your registration for Convention 55 is Confirmed.. Your payment amount(" + lblAmount.Text + ") and trxID: " + lblTransactionID.Text + "<br/>This is system generated payment confirmation mail.<hr/>We will send you the money receipt before 27th April<hr/>With regards<br/>IT Section, IEB<br/>01766674142";
//Sendmail.sendEmail(lblEmail.Text, "IEB Convention 55 Regsitration fee payment confirmation", mialMessage);
}
catch (Exception ex)
{ }
}
}
}
catch (Exception ex)
{ }
}
btnSearch_Click(this, new EventArgs());
}
private void showConv_RegistrationGrid()
{
decimal total = 0;
decimal totalbKash = 0;
List <Conv_Registration> conventionRegistrations = new List <Conv_Registration>();
if (rbtnlPyament.SelectedValue == "3")
{
conventionRegistrations = Conv_RegistrationManager.GetAllConv_Registrations();
foreach (Conv_Registration item in conventionRegistrations)
{
item.ExtraField5 = "../MembersArea/ConventionPaymentPrint.aspx?Conv_RegistrationID=710307" + item.Conv_RegistrationID + "034438";
}
return;
gvConv_Registration.DataSource = conventionRegistrations;
}
else if (rbtnlPyament.SelectedValue == "2")
{
string sql = @"SELECT [Conv_Registration].[Conv_RegistrationID]
,[Conv_Registration].[Conv_ConventionID]
,[Conv_Registration].[Mem_MemberID]
,[Conv_Registration].[RegistrationFee]
,[Conv_Registration].[Lunch1No]
,[Conv_Registration].[Lunch1Amount]
,[Conv_Registration].[Lunch2No]
,[Conv_Registration].[Lunch2Amount]
,[Conv_Registration].[Dinner1]
,[Conv_Registration].[Dinner2]
,[Conv_Registration].[LadiesBag]
,[Conv_Registration].[IEBTie]
,[Conv_Registration].[TotalIEBFee]
,[Conv_Registration].[bKashFees]
,[Conv_Registration].[TotalPayable]
,[Conv_Registration].[TrxID]
,[Conv_Registration].[AddedDate]
,[Conv_Registration].[TypeID]
,[Conv_Registration].[StatusID]
,[Conv_Registration].[ExtraField1]
,[Conv_Registration].[ExtraField2]
,[Conv_Registration].[ExtraField3]
,Mem_Member.MemberShipNo as [ExtraField4]
,[Conv_Registration].[ExtraField5]
,Mem_Member.Mobile
FROM [Conv_Registration]
inner join Mem_Member on Mem_Member.Mem_MemberID = Conv_Registration.Mem_MemberID
where TrxID=''
order by [Conv_Registration].AddedDate desc
";
DataSet ds = DatabaseManager.ExecSQL(sql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
dr["ExtraField5"] = "../MembersArea/ConventionPaymentPrint.aspx?Conv_RegistrationID=710307" + dr["Conv_RegistrationID"].ToString() + "034438";
}
gvConv_Registration.DataSource = ds.Tables[0];
//conventionRegistrations = Conv_RegistrationManager.GetAllConv_Registrations().FindAll(x => x.TrxID == "");
}
else if (rbtnlPyament.SelectedValue == "1")
{
string sql = @"SELECT [Conv_Registration].[Conv_RegistrationID]
,[Conv_Registration].[Conv_ConventionID]
,[Conv_Registration].[Mem_MemberID]
,[Conv_Registration].[RegistrationFee]
,[Conv_Registration].[Lunch1No]
,[Conv_Registration].[Lunch1Amount]
,[Conv_Registration].[Lunch2No]
,[Conv_Registration].[Lunch2Amount]
,[Conv_Registration].[Dinner1]
,[Conv_Registration].[Dinner2]
,[Conv_Registration].[LadiesBag]
,[Conv_Registration].[IEBTie]
,[Conv_Registration].[TotalIEBFee]
,[Conv_Registration].[bKashFees]
,[Conv_Registration].[TotalPayable]
,[Conv_Registration].[TrxID]
,[Conv_Registration].[AddedDate]
,[Conv_Registration].[TypeID]
,[Conv_Registration].[StatusID]
,[Conv_Registration].[ExtraField1]
,[Conv_Registration].[ExtraField2]
,[Conv_Registration].[ExtraField3]
,Mem_Member.MemberShipNo as [ExtraField4]
,[Conv_Registration].[ExtraField5]
,Mem_Member.Mobile
FROM [Conv_Registration]
inner join Mem_Member on Mem_Member.Mem_MemberID = Conv_Registration.Mem_MemberID
where TrxID <>''
order by [Conv_Registration].AddedDate desc ";
DataSet ds = DatabaseManager.ExecSQL(sql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
total += decimal.Parse(dr["TotalIEBFee"].ToString());
totalbKash += decimal.Parse(dr["TotalPayable"].ToString());
dr["ExtraField5"] = "../MembersArea/ConventionPaymentPrint.aspx?Conv_RegistrationID=710307" + dr["Conv_RegistrationID"].ToString() + "034438";
}
gvConv_Registration.DataSource = ds.Tables[0];
}
gvConv_Registration.DataBind();
((Label)gvConv_Registration.FooterRow.FindControl("lblTotalFooter")).Text = total.ToString("0,0") + "+" + (totalbKash - total).ToString("0,0") + "=" + totalbKash.ToString("0,0");
}
