protected void btnWithdraw_Click(object sender, EventArgs e)
{
//lblMSG.Text = string.Empty;
if (Convert.ToDecimal(txtAmount.Text) >= 10)
{
UserWithdrawRequest userWithdrawRequest = new UserWithdrawRequest();
userWithdrawRequest = LoadUserWithdrawRequest(userWithdrawRequest);
using (TheFacade _facade = new TheFacade())
{
_facade.Insert<UserWithdrawRequest>(userWithdrawRequest);
if (userWithdrawRequest.IID > 0)
{
UserTransactionHistory userTransactionHistory = new UserTransactionHistory();
LoadUserTransactionHistory(userTransactionHistory, userWithdrawRequest);
_facade.Insert<UserTransactionHistory>(userTransactionHistory);
_facade.ZiaFacade.UpdateBalanceForWithdraw(CurrentUserID, userWithdrawRequest.Amount);
}
}
Response.Redirect(Request.Url.ToString());
}
else
{
lblMSG.Text = "The Amount must be greater than or equal to 10";
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
// create membership user
//Please check first anyuser already has same email
MembershipUser user = null;
//txtPassword.Text = Convert.ToInt32(123456).ToString();
string Password = txtPassword.Text.Trim();
string UserName = txtEmail.Text.Trim();
try
{
user = Membership.CreateUser(UserName, Password);
}
catch (Exception ex)
{
}
//create system User
if (user != null)
{
SystemUser systemuser = new SystemUser();
systemuser = CreateSystemUser(user.ProviderUserKey.ToString());
using (TheFacade facade = new TheFacade())
{
facade.Insert <SystemUser>(systemuser);
}
}
// create Member
Member member = new Member();
member = CreateMamber(user.ProviderUserKey.ToString());
using (TheFacade facade = new TheFacade())
{
facade.Insert <Member>(member);
}
// add varification data with pending status
Ins_MemberVerification memberVerification = new Ins_MemberVerification();
memberVerification.MemberID = member.ID;
memberVerification.Status = (int)EnumCollection.VerificationStatus.Pending;
//memberVerification.LastUpdateDate = D
using (TheFacade facade = new TheFacade())
{
facade.Insert <Ins_MemberVerification>(memberVerification);
List <Ins_VerificationType> typeList = facade.MemberFacade.GetAllVerificationType();
foreach (Ins_VerificationType type in typeList)
{
Ins_MemberVerificationDetail detail = new Ins_MemberVerificationDetail();
detail.MemberID = member.ID;
detail.Status = (int)EnumCollection.VerificationStatus.Pending;
detail.VerificationTypeId = type.IID;
facade.Insert <Ins_MemberVerificationDetail>(detail);
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Ins_ChaForm chaForm = new Ins_ChaForm();
using (TheFacade facade = new TheFacade())
{
if (CurrentChaFormID > 0)
{
chaForm = facade.InsentiveFacade.GetChaFormByID(CurrentChaFormID);
}
CreateChaForm(chaForm);
if (CurrentChaFormID > 0)
{
facade.Update <Ins_ChaForm>(chaForm);
}
else
{
chaForm.Status = Convert.ToInt32(EnumCollection.ChaFormStatus.Draft);
facade.Insert <Ins_ChaForm>(chaForm);
}
List <Ins_ChaFormInvoice> chaFormInvoices = facade.InsentiveFacade.GetchaFormInvoiceByChaFormID(chaForm.ID);
//TODO: Get invoiceIds from Session["InvoiceIds"];
foreach (Ins_ChaFormInvoice item in chaFormInvoices)
{
facade.Delete <Ins_ChaFormInvoice>(item);
}
var invoiceIds = new List <long>();
//List<Ins_ChaFormInvoice> list = new List<Ins_ChaFormInvoice>();
if (Session["InvoiceIds"] != null)
{
var invoiceIdsFromSession = (List <long>)Session["InvoiceIds"];
invoiceIds.AddRange(invoiceIdsFromSession);
}
foreach (var invoiceId in invoiceIds)
{
var chaInvoice = new Ins_ChaFormInvoice();
chaInvoice.InvoiceMasterId = invoiceId;
chaInvoice.ChaFormId = chaForm.ID;
facade.Insert <Ins_ChaFormInvoice>(chaInvoice);
}
}
lblmessage.Text = "Data save successfully";
lblmessage.Visible = true;
}
protected void btnSave_Click(object sender, EventArgs e)
{
using (TheFacade facade = new TheFacade())
{
if (!IsValidData())
{
//Error msg
lblMsg.Text = "Category Name already exist";
return;
}
Ins_ItemCategory item = new Ins_ItemCategory();
if (SelectedItemId > 0)
{
item = facade.InsentiveFacade.GetCategoryByID(SelectedItemId);
item.Name = txtName.Text;
item.Code = txtCode.Text;
item.IsRemoved = 0;
item.UpdateBy = 1;
item.UpdateDate = DateTime.Now;
facade.Update <Ins_ItemCategory>(item);
}
else
{
item.Name = txtName.Text;
item.Code = txtCode.Text;
item.IsRemoved = 0;
item.UpdateBy = 1;
item.UpdateDate = DateTime.Now;
item.CreateBy = 1;//sustemuserid
item.CreateDate = DateTime.Now;
facade.Insert <Ins_ItemCategory>(item);
}
}
Response.Redirect(Request.Url.ToString());
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
using (TheFacade facade = new TheFacade())
{
if (CurrentAddID <= 0)
{
Advertise advertise = new Advertise();
advertise.Name = txtName.Text.Trim();
advertise.Url = txtUrl.Text.Trim();
facade.Insert<Advertise>(advertise);
}
else if (CurrentAddID > 0)
{
Advertise advertise = facade.GeneralFacade.GetAdvertiseByIID(CurrentAddID);
advertise.Name = txtName.Text.Trim();
advertise.Url = txtUrl.Text.Trim();
facade.Update<Advertise>(advertise);
}
}
Session[GeneralConstant.ISSAVED] = true;
}
catch
{
Session[GeneralConstant.ISSAVED] = true;
}
finally
{
Response.Redirect(Request.Url.ToString());
}
}
private void SaveUpdateInvoiceDetail(long invoiceID, TheFacade facade)
{
Inv_Detail invoiceDetail;
Ins_MemberItem item = facade.InsentiveFacade.GetMemberItemById(Convert.ToInt64(ddlItem.SelectedValue));
if (InvoiceDetailId <= 0)
{
if (!string.IsNullOrWhiteSpace(txtUnitPrice.Text) && !string.IsNullOrWhiteSpace(txtQuantity.Text) &&
Convert.ToInt32(ddlItem.SelectedValue) > 0)
{
invoiceDetail = new Inv_Detail();
invoiceDetail.InvMasterId = invoiceID;
invoiceDetail.InsMemberItemId = Convert.ToInt64(ddlItem.SelectedValue);
invoiceDetail.Quantity = Convert.ToInt32(txtQuantity.Text);
//invoiceDetail.UnitPrice = Convert.ToInt32(txtUnitPrice.Text);
invoiceDetail.UnitPrice = Convert.ToDecimal(txtUnitPrice.Text);
invoiceDetail.CartonSize = Convert.ToInt32(txtCartonSize.Text);
invoiceDetail.TotalItemCount = invoiceDetail.Quantity * invoiceDetail.CartonSize;
invoiceDetail.TotalAmount = invoiceDetail.Quantity * invoiceDetail.UnitPrice;
invoiceDetail.TotalWeight = string.IsNullOrEmpty(txtNetWeight.Text)?0: Convert.ToDecimal(txtNetWeight.Text); //item.ItemWeight.Value * invoiceDetail.TotalItemCount;
invoiceDetail.GrossWeight = string.IsNullOrEmpty(txtGrossWeight.Text) ? 0 : Convert.ToDecimal(txtGrossWeight.Text); //invoiceDetail.TotalWeight + Convert.ToDecimal(invoiceDetail.CartonSize * 0.2);
invoiceDetail.CreateBy = 1; //sustemuserid
invoiceDetail.CreateDate = DateTime.Now;
invoiceDetail.IsRemoved = 0;
invoiceDetail.UpdateBy = 1; //sustemuserid
invoiceDetail.UpdateDate = DateTime.Now;
facade.Insert <Inv_Detail>(invoiceDetail);
}
}
else
{
invoiceDetail = facade.InvoiceFacade.GetInvoiceDetailByID(InvoiceDetailId);
invoiceDetail.InvMasterId = invoiceID;
invoiceDetail.InsMemberItemId = Convert.ToInt32(ddlItem.SelectedValue);
invoiceDetail.Quantity = Convert.ToInt32(txtQuantity.Text);
invoiceDetail.UnitPrice = Convert.ToDecimal(txtUnitPrice.Text);
invoiceDetail.CartonSize = Convert.ToInt32(txtCartonSize.Text);
invoiceDetail.TotalItemCount = invoiceDetail.Quantity * invoiceDetail.CartonSize;
invoiceDetail.TotalAmount = invoiceDetail.Quantity * invoiceDetail.UnitPrice;
invoiceDetail.TotalWeight = string.IsNullOrEmpty(txtNetWeight.Text) ? 0 : Convert.ToDecimal(txtNetWeight.Text); //item.ItemWeight.Value * invoiceDetail.TotalItemCount;
invoiceDetail.GrossWeight = string.IsNullOrEmpty(txtGrossWeight.Text) ? 0 : Convert.ToDecimal(txtGrossWeight.Text); //invoiceDetail.TotalWeight + Convert.ToDecimal(invoiceDetail.CartonSize * 0.2);
//invoiceDetail.TotalWeight = item.ItemWeight.Value * invoiceDetail.TotalItemCount;
//invoiceDetail.GrossWeight = invoiceDetail.TotalWeight + Convert.ToDecimal(invoiceDetail.CartonSize * 0.2);
invoiceDetail.UpdateBy = 1;//sustemuserid
invoiceDetail.UpdateDate = DateTime.Now;
facade.Update <Inv_Detail>(invoiceDetail);
}
}
protected void btnGenerateKey_Click(object sender, EventArgs e)
{
UserKeyInfo keyInfo = new UserKeyInfo();
keyInfo.Amount = Convert.ToDecimal(txtAmount.Text);
keyInfo.CreatedDate = DateTime.Now;
keyInfo.Status = Convert.ToInt32(EnumHelper.RegistrationKeyStatus.User_Not_Created);
keyInfo.UserPaymetType = Convert.ToInt32(ddlPaymetType.SelectedValue.ToString());
keyInfo.UserKey = Guid.NewGuid();
keyInfo.KeyTaker = txtName.Text;
keyInfo.KeyTakerPhone = txtPhoneNo.Text;
using (TheFacade facade = new TheFacade())
{
facade.Insert<UserKeyInfo>(keyInfo);
}
if (keyInfo.IID > 0)
{
lblGenerateKey.Text = keyInfo.UserKey.ToString();
}
}
private void btnAddUser_Click(object sender, EventArgs e)
{
tblUser user = new tblUser();
user.Name = txtAddUser.Text.ToUpper();
using (TheFacade facade = new TheFacade())
{
if (user.Name != null)
{
facade.Insert <tblUser>(user);
MessageBox.Show("Succeed!!");
txtAddUser.Text = "";
}
else
{
MessageBox.Show("error!!");
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (SelectedItemId <= 0)
{
Ins_MemberItem item = new Ins_MemberItem();
item.Name = txtName.Text;
item.ItemID = Convert.ToInt32(ddlItem.SelectedValue);
item.MemberID = Convert.ToInt32(ddlMember.SelectedValue);
item.Code = txtProductCode.Text;
item.ItemWeight = Convert.ToDecimal(txtProductWeight.Text);
item.CreateBy = 1;//sustemuserid
item.CreateDate = DateTime.Now;
item.IsRemoved = 0;
item.UpdateBy = 1;//sustemuserid
item.UpdateDate = DateTime.Now;
using (TheFacade facade = new TheFacade())
{
facade.Insert <Ins_MemberItem>(item);
Response.Redirect(Request.Url.ToString());
}
}
else
{
using (TheFacade facade = new TheFacade())
{
Ins_MemberItem item = facade.InsentiveFacade.GetMemberItemByIdForUpdate(SelectedItemId);
item.Name = txtName.Text;
item.MemberID = Convert.ToInt32(ddlMember.SelectedValue);
item.ItemID = Convert.ToInt32(ddlItem.SelectedValue);
item.Code = txtProductCode.Text;
item.ItemWeight = Convert.ToDecimal(txtProductWeight.Text);
item.UpdateBy = 1;//sustemuserid
item.UpdateDate = DateTime.Now;
facade.Update <Ins_MemberItem>(item);
Response.Redirect(Request.Url.ToString());
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (SelectedItemId <= 0)
{
Ins_Item item = new Ins_Item();
item.Name = txtName.Text;
item.Code = txtCode.Text;
item.MeasurementUnitID = Convert.ToInt32(ddlMesumentUnit.SelectedValue);
item.CategoryID = Convert.ToInt32(ddlItemCetagory.SelectedValue);
item.CreateBy = 1;//sustemuserid
item.CreateDate = DateTime.Now;
item.IsRemoved = 0;
item.UpdateBy = 1;//sustemuserid
item.UpdateDate = DateTime.Now;
using (TheFacade facade = new TheFacade())
{
facade.Insert <Ins_Item>(item);
Response.Redirect(Request.Url.ToString());
}
}
else
{
using (TheFacade facade = new TheFacade())
{
Ins_Item item = facade.InsentiveFacade.GetItemByID(SelectedItemId);
item.Name = txtName.Text;
item.Code = txtCode.Text;
item.MeasurementUnitID = Convert.ToInt32(ddlMesumentUnit.SelectedValue);
item.CategoryID = Convert.ToInt32(ddlItemCetagory.SelectedValue);
item.UpdateBy = 1;//sustemuserid
item.UpdateDate = DateTime.Now;
facade.Update <Ins_Item>(item);
Response.Redirect(Request.Url.ToString());
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//if (Session["BranchID"] != null)
//{
try
{
if (CurrentMemberID > 0)
{
using (TheFacade facade = new TheFacade())
{
Member member = facade.MemberFacade.GetMemberById(CurrentMemberID);
if (member != null && member.MemberVerificationStatus == (int)EnumCollection.VerificationStatus.Approved_for_Committee_Meeting)
{
member.MemberVerificationStatus = (int)EnumCollection.VerificationStatus.Completed;
member.MembershipStatus = (int)EnumCollection.MembershipStatus.Approved;
DateTime expireDate = new DateTime(DateTime.Now.Year, 6, 30);
if (DateTime.Now.Date > expireDate)
{
expireDate = expireDate.AddYears(1);
}
try
{
expireDate = Convert.ToDateTime(txtExpireDate.Text);
}
catch (Exception ex)
{
}
member.MembershipCode = txtMembershipCode.Text;
facade.Update <Member>(member);
Ins_MembershipExpireInfo info = new Ins_MembershipExpireInfo();
info.MemberID = member.ID;
info.ExpireDate = expireDate.Date;
info.CreateBy = 1;
info.CreateDate = DateTime.Now;
info.UpdateBy = 1;
info.UpdateDate = DateTime.Now;
info.IsRemoved = 0;
facade.Insert <Ins_MembershipExpireInfo>(info);
Ins_MemberVerification memberVerification = facade.MemberFacade.GetMemberVerificationByMemberID(member.ID);
if (memberVerification != null)
{
memberVerification.Status = (int)EnumCollection.VerificationStatus.Completed;
facade.Update <Ins_MemberVerification>(memberVerification);
}
Acc_ChartOfAccount chartofAcc = facade.AccountsFacade.GetAcc_ChartOfAccountByName("Account Receivable");
Acc_ChartOfAccountMember customerAccount = new Acc_ChartOfAccountMember();
#region acc
Acc_ChartOfAccount newAccount = new Acc_ChartOfAccount();
newAccount.AccountNo = GenerateAccountNo(chartofAcc.Gparent.ToString());
newAccount.Name = member.Name;
newAccount.IsActive = 1;
newAccount.AccountTypeID = Convert.ToInt32(EnumCollection.AccountType.Transactable);
newAccount.ParentID = chartofAcc.IID;
newAccount.Gparent = chartofAcc.Gparent;
newAccount.OpeningBalance = Convert.ToDecimal(txtOpeningBalance.Text);
newAccount.CreateBy = 1;
newAccount.UpdateBy = 1;
newAccount.CreateDate = DateTime.Now;
newAccount.UpdateDate = DateTime.Now;
newAccount.IsRemoved = 0;
facade.Insert <Acc_ChartOfAccount>(newAccount);
#endregion
customerAccount.ChartofAccountID = newAccount.IID;
customerAccount.MemberID = member.ID;
customerAccount.UpdateDate = DateTime.Now;
customerAccount.UpdateBy = 1;
customerAccount.CreateDate = DateTime.Now;
customerAccount.CreateBy = 1;
customerAccount.IsRemoved = 0;
facade.Insert <Acc_ChartOfAccountMember>(customerAccount);
}
else
{
Session["duplicate"] = true;
}
}
}
else
{
using (TheFacade facade = new TheFacade())
{
}
}
Session["IsSaved"] = true;
}
catch
{
Session["IsSaved"] = false;
}
finally
{
Response.Redirect(Request.Url.ToString());
}
//}
//else
//{
// FormsAuthentication.SignOut();
// Roles.DeleteCookie();
// Session.Abandon();
// Response.Redirect("~/login.aspx");
//}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
//Image Upload
//string filename = FileUpload1.FileName;
//FileUpload1.PostedFile.SaveAs(Server.MapPath("~\\UploadMemberCertificates\\" + filename.Trim()));
//string path = "~\\UploadMemberCertificates\\" + filename.Trim();
#region ex
//if (Request.Files["UploadedFile"] != null)
//{
// HttpPostedFile MyFile = Request.Files["UploadedFile"];
// //Setting location to upload files
// string TargetLocation = Server.MapPath("~/UploadMemberCertificates/");
// try
// {
// if (MyFile.ContentLength > 0)
// {
// //Determining file name. You can format it as you wish.
// string FileName = MyFile.FileName;
// //Determining file size.
// int FileSize = MyFile.ContentLength;
// //Creating a byte array corresponding to file size.
// byte[] FileByteArray = new byte[FileSize];
// //Posted file is being pushed into byte array.
// MyFile.InputStream.Read(FileByteArray, 0, FileSize);
// //Uploading properly formatted file to server.
// MyFile.SaveAs(TargetLocation + FileName);
// }
// }
// catch (Exception BlueScreen)
// {
// //Handle errors
// }
//}
#endregion
MembershipUser user = null;
string Password = txtPassword.Text.Trim();
string UserName = txtEmail.Text.Trim();
try
{
user = Membership.CreateUser(UserName, Password);
}
catch (Exception ex)
{
lblmessage.Text = "User Name is Already Created";
}
//create system User
if (user == null)
{
lblmessage.Text = "User failed to create. Please contract with system administrator.";
return;
}
if (user != null)
{
SystemUser systemuser = new SystemUser();
systemuser = CreateSystemUser(user.ProviderUserKey.ToString());
using (TheFacade facade = new TheFacade())
{
facade.Insert <SystemUser>(systemuser);
}
}
else
{
lblmessage.Text = "User Name is Already Created";
}
//create Member
Member member = new Member();
member = CreateMamber(user.ProviderUserKey.ToString());
using (TheFacade facade = new TheFacade())
{
facade.Insert <Member>(member);
}
// Add role
//Roles.AddUserToRole(user.UserName, "User");
//create Member Document
List <MemberDocument> memberDocuments = new List <MemberDocument>();
memberDocuments = CreateMemberDocument(member.ID);
foreach (var item in memberDocuments)
{
using (TheFacade facade = new TheFacade())
{
facade.Insert <MemberDocument>(item);
}
}
// add varification data with pending status
Ins_MemberVerification memberVerification = new Ins_MemberVerification();
memberVerification.MemberID = member.ID;
memberVerification.Status = (int)EnumCollection.VerificationStatus.Pending;
//memberVerification.LastUpdateDate = D
using (TheFacade facade = new TheFacade())
{
facade.Insert <Ins_MemberVerification>(memberVerification);
List <Ins_VerificationType> typeList = facade.MemberFacade.GetAllVerificationType();
foreach (Ins_VerificationType type in typeList)
{
Ins_MemberVerificationDetail detail = new Ins_MemberVerificationDetail();
detail.MemberID = member.ID;
detail.Status = (int)EnumCollection.VerificationStatus.Pending;
detail.VerificationTypeId = type.IID;
facade.Insert <Ins_MemberVerificationDetail>(detail);
Response.Redirect("");
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (IsDuplicateInvoiceNo())
{
lblMessage.Text = string.Format("The Invoice No {0} already exist. Please try with another Invoice No", txtInvoiceNo.Text);
return;
}
using (TheFacade facade = new TheFacade())
{
if (InvoiceId <= 0)
{
Inv_Master invoice = new Inv_Master();
invoice.CurrencyId = Convert.ToInt32(ddlCurrency.SelectedValue);
//invoice.Date = Convert.ToDateTime(txtDate.Text);
//DateTime dt = DateTime.ParseExact(txtDate.Text, "dd/M/yyyy", CultureInfo.InvariantCulture);
//invoice.Date = dt;//
invoice.Date = Convert.ToDateTime(txtDate.Text);
invoice.DollarAmount = 0;//will be updated later
invoice.DollarCounversionRate = Convert.ToDecimal(txtConversionRate.Text);
invoice.Number = txtInvoiceNo.Text;
invoice.CreateBy = 1;//sustemuserid
invoice.CreateDate = DateTime.Now;
invoice.IsRemoved = 0;
invoice.UpdateBy = 1;//sustemuserid
invoice.UpdateDate = DateTime.Now;
invoice.MemberId = MemberID;
invoice.ExportedLocalItemDescription = txtLocalItemDescription.Text;
invoice.ExportedLocalItemQuantity = txtLoacItemQuantity.Text;
invoice.ExportedLocalItemAmount = Convert.ToDecimal(txtLocalItemAmount.Text);
invoice.ExportedLocalDistrubuterNameAndAddress = txtLocalDistrubuterNameAndAddress.Text;
invoice.CountryID = Convert.ToInt64(ddlCountry.SelectedValue.ToString());
try {
facade.Insert <Inv_Master>(invoice);
SaveUpdateInvoiceDetail(invoice.IID, facade);
InvoiceId = invoice.IID;
}
catch (Exception ex)
{
if (ex.Message.Contains("Violation of UNIQUE KEY constraint"))
{
lblMessage.Text = "Please Insert Unique Invoice Number";
}
else
{
lblMessage.Text = "Data Not Successfully Saved";
}
}
}
else
{
Inv_Master invoice = facade.InvoiceFacade.GetInvoiceByIDForUpdate(InvoiceId);
invoice.CurrencyId = Convert.ToInt32(ddlCurrency.SelectedValue);
//DateTime dt = DateTime.ParseExact(txtDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
//invoice.Date = dt;// Convert.ToDateTime(txtDate.Text);
invoice.Date = Convert.ToDateTime(txtDate.Text);
invoice.DollarAmount = 0;;//will be updated later
invoice.DollarCounversionRate = Convert.ToDecimal(txtConversionRate.Text);
invoice.Number = txtInvoiceNo.Text;
invoice.UpdateBy = 1;//sustemuserid
invoice.UpdateDate = DateTime.Now;
invoice.MemberId = MemberID;
invoice.ExportedLocalItemDescription = txtLocalItemDescription.Text;
invoice.ExportedLocalItemQuantity = txtLoacItemQuantity.Text;
invoice.ExportedLocalItemAmount = Convert.ToDecimal(txtLocalItemAmount.Text);
invoice.ExportedLocalDistrubuterNameAndAddress = txtLocalDistrubuterNameAndAddress.Text;
invoice.CountryID = Convert.ToInt64(ddlCountry.SelectedValue.ToString());
facade.Update <Inv_Master>(invoice);
SaveUpdateInvoiceDetail(invoice.IID, facade);
}
UpdateDollarAmount(facade, InvoiceId);
}
//Response.Redirect(Request.Url.ToString());
//SHUVO
string redirectUrl = Request.Url.GetLeftPart(UriPartial.Path).ToString() + "?invId=" + InvoiceId.ToString();
Response.Redirect(redirectUrl);
}
protected void btnUpload_Click(object sender, EventArgs e)
{
if (fuEnclosedDoc.HasFile && !string.IsNullOrEmpty(txtDocumentName.Text))
{
string fileExtention = Path.GetExtension(fuEnclosedDoc.FileName);
string path = string.Format("~/MemberData/InvoiceEnclosedDocument/{0}/", InvoiceId.ToString());
string fileName = Server.MapPath(path) + txtDocumentName.Text + fileExtention;
if (CurrentDocumentID <= 0)
{
try
{
if (!Directory.Exists(Server.MapPath(path)))
{
Directory.CreateDirectory(Server.MapPath(path));
}
fuEnclosedDoc.SaveAs(fileName);
using (TheFacade facade = new TheFacade())
{
Ins_InvoiceEnclosedDocument document = new Ins_InvoiceEnclosedDocument();
document.Name = txtDocumentName.Text;
document.FileName = txtDocumentName.Text + fileExtention;
document.Path = path + document.FileName;
document.InvoiceID = InvoiceId;
document.CreatedDate = DateTime.Now;
facade.Insert <Ins_InvoiceEnclosedDocument>(document);
}
}
catch (Exception ex)
{
}
}
else
{
using (TheFacade facade = new TheFacade())
{
Ins_InvoiceEnclosedDocument document = facade.InsentiveFacade.GetInvoiceEnclosedDocumentByID(CurrentDocumentID);
string existingFile = Server.MapPath(path) + document.FileName;
if (File.Exists(existingFile))
{
File.Delete(existingFile);
}
if (!Directory.Exists(Server.MapPath(path)))
{
Directory.CreateDirectory(Server.MapPath(path));
}
fuEnclosedDoc.SaveAs(fileName);
document.Name = txtDocumentName.Text;
document.FileName = txtDocumentName.Text + fileExtention;
document.Path = path + document.FileName;
document.InvoiceID = InvoiceId;
document.CreatedDate = DateTime.Now;
facade.Update <Ins_InvoiceEnclosedDocument>(document);
}
}
}
//CurrentDocumentID = 0;
//txtDocumentName.Text = string.Empty;
//LoadInvoiceEnclosedDocument();
Response.Redirect(Request.Url.ToString());
}
//Account Number Generate
public long GetMemberForAccount(long CurrentMemberID)
{
try
{
if (CurrentMemberID > 0)
{
using (TheFacade facade = new TheFacade())
{
Member member = facade.MemberFacade.GetMemberById(CurrentMemberID);
if (member != null)
{
member.MemberVerificationStatus = (int)EnumCollection.VerificationStatus.Completed;
member.MembershipStatus = (int)EnumCollection.MembershipStatus.Approved;
DateTime expireDate = new DateTime(DateTime.Now.Year, 6, 30);
if (DateTime.Now.Date > expireDate)
{
expireDate = expireDate.AddYears(1);
}
try
{
expireDate = Convert.ToDateTime(txtExpireDate.Text);
}
catch (Exception ex)
{
}
member.MembershipCode = txtMembershipCode.Text;
facade.Update <Member>(member);
Ins_MembershipExpireInfo info = new Ins_MembershipExpireInfo();
info.MemberID = member.ID;
info.ExpireDate = expireDate.Date;
info.CreateBy = 1;
info.CreateDate = DateTime.Now;
info.UpdateBy = 1;
info.UpdateDate = DateTime.Now;
info.IsRemoved = 0;
facade.Insert <Ins_MembershipExpireInfo>(info);
Ins_MemberVerification memberVerification = facade.MemberFacade.GetMemberVerificationByMemberID(member.ID);
if (memberVerification != null)
{
memberVerification.Status = (int)EnumCollection.VerificationStatus.Completed;
facade.Update <Ins_MemberVerification>(memberVerification);
}
Acc_ChartOfAccount chartofAcc = facade.AccountsFacade.GetAcc_ChartOfAccountByName("Account Receivable");
Acc_ChartOfAccountMember customerAccount = new Acc_ChartOfAccountMember();
#region acc
Acc_ChartOfAccount newAccount = new Acc_ChartOfAccount();
newAccount.AccountNo = GenerateAccountNo(chartofAcc.Gparent.ToString());
newAccount.Name = member.Name;
newAccount.IsActive = 1;
newAccount.AccountTypeID = Convert.ToInt32(EnumCollection.AccountType.Transactable);
newAccount.ParentID = chartofAcc.IID;
newAccount.Gparent = chartofAcc.Gparent;
newAccount.OpeningBalance = Convert.ToDecimal(txtOpeningBalance.Text);
newAccount.CreateBy = 1;
newAccount.UpdateBy = 1;
newAccount.CreateDate = DateTime.Now;
newAccount.UpdateDate = DateTime.Now;
newAccount.IsRemoved = 0;
facade.Insert <Acc_ChartOfAccount>(newAccount);
#endregion
customerAccount.ChartofAccountID = newAccount.IID;
customerAccount.MemberID = member.ID;
customerAccount.UpdateDate = DateTime.Now;
customerAccount.UpdateBy = 1;
customerAccount.CreateDate = DateTime.Now;
customerAccount.CreateBy = 1;
customerAccount.IsRemoved = 0;
facade.Insert <Acc_ChartOfAccountMember>(customerAccount);
}
else
{
Session["duplicate"] = true;
}
}
}
else
{
using (TheFacade facade = new TheFacade())
{
}
}
Session["IsSaved"] = true;
}
catch
{
Session["IsSaved"] = false;
}
finally
{
Response.Redirect(Request.Url.ToString());
}
lablmessage.Text = " Registration & Account Create Succesfully";
return(CurrentMemberID);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
//using (TheFacade facade = new TheFacade())
//{
// Member checkMember = facade.MemberFacade.GetMemberByName(txtCompanyName.Text.Trim());
// if(checkMember.Name != null)
// {
// lblmessage.Text = "Company Name is Already Exist !";
// Response.Redirect("ExistingMember.aspx");
// }
//}
// create membership user
//Please check first anyuser already has same email
MembershipUser user = null;
//txtPassword.Text = Convert.ToInt32(123456).ToString();
string Password = txtPassword.Text.Trim();
string UserName = txtEmail.Text.Trim();
try
{
user = Membership.CreateUser(UserName, Password);
}
catch (Exception ex)
{
}
//create system User
if (user != null)
{
SystemUser systemuser = new SystemUser();
systemuser = CreateSystemUser(user.ProviderUserKey.ToString());
using (TheFacade facade = new TheFacade())
{
facade.Insert <SystemUser>(systemuser);
}
}
// create Member
Member member = new Member();
member = CreateMamber(user.ProviderUserKey.ToString());
using (TheFacade facade = new TheFacade())
{
facade.Insert <Member>(member);
}
// add varification data with pending status
Ins_MemberVerification memberVerification = new Ins_MemberVerification();
memberVerification.MemberID = member.ID;
memberVerification.Status = (int)EnumCollection.VerificationStatus.Pending;
//memberVerification.LastUpdateDate = D
using (TheFacade facade = new TheFacade())
{
facade.Insert <Ins_MemberVerification>(memberVerification);
List <Ins_VerificationType> typeList = facade.MemberFacade.GetAllVerificationType();
foreach (Ins_VerificationType type in typeList)
{
Ins_MemberVerificationDetail detail = new Ins_MemberVerificationDetail();
detail.MemberID = member.ID;
detail.Status = (int)EnumCollection.VerificationStatus.Pending;
detail.VerificationTypeId = type.IID;
facade.Insert <Ins_MemberVerificationDetail>(detail);
}
}
// Account Create
GetMemberForAccount(member.ID);
lablmessage.Text = " Registration & Account Create Succesfully";
//member.ID =
}
private void SaveMemberVerificationStatusDetail(int typeID)
{
Ins_MemberVerificationDetail verificationDetail = new Ins_MemberVerificationDetail();
bool isNew = false;
using (TheFacade facade = new TheFacade())
{
Ins_MemberVerification memberVerification = facade.MemberFacade.GetMemberVerificationByMemberID(MemberID);
Member member = facade.MemberFacade.GetMemberById(MemberID);
member.MemberVerificationStatus = (int)VerificationStatus.Processing;
facade.Update <Member>(member);
if (memberVerification != null)
{
memberVerification.Status = (int)VerificationStatus.Processing;
facade.Update <Ins_MemberVerification>(memberVerification);
}
verificationDetail = facade.MemberFacade.GetMemberVerificationDetailByType(MemberID, typeID);
if (verificationDetail == null)
{
verificationDetail = new Ins_MemberVerificationDetail();
isNew = true;
}
switch (typeID)
{
case 1:
if (radioVType11.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment1.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 2:
if (radioVType13.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment2.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 3:
if (radioVType15.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment3.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 4:
if (radioVType17.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment4.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 5:
if (radioVType19.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment5.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 6:
if (radioVType21.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment6.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 7:
if (radioVType23.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment7.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 8:
if (radioVType25.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment8.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 9:
if (radioVType27.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment9.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 10:
if (radioVType29.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment10.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 11:
if (radioVType31.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment11.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 12:
if (radioVType33.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment12.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 13:
if (radioVType35.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment13.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 14:
if (radioVType37.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment14.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 15:
if (radioVType39.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment15.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 16:
if (radioVType41.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment16.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 17:
if (radioVType43.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment17.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 18:
if (radioVType45.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment18.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
case 19:
if (radioVType47.Checked)
{
verificationDetail.Status = 1;
}
else
{
verificationDetail.Status = 0;
}
verificationDetail.Comment = txtComment19.Text;
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
default:
verificationDetail.LastUpdated = DateTime.Now;
if (isNew)
{
try
{
verificationDetail.VerificationTypeId = typeID;
facade.Insert <Ins_MemberVerificationDetail>(verificationDetail);
}
catch (Exception ex) { }
}
else
{
facade.Update <Ins_MemberVerificationDetail>(verificationDetail);
}
break;
}
LoadApprovedButton();
}
}
protected void Timer1_Tick(object sender, EventArgs e)
{
if (CurrentCountDown > 0)
{
CurrentCountDown = CurrentCountDown - 1;
Label1.Text = CurrentCountDown.ToString();
if (CurrentCountDown == 0)
{
//btnDone.Enabled = true;
// User daily link click ins/upd
// userbalance upd/ins
// ins usertransactionhistory
using (TheFacade facade = new TheFacade())
{
UserDailyLinkClick userDailyLinkClickOld = facade.AdvertiseFacade.GetUserDailyLinkClickToday(DateTime.Now.Date,CurrentUserID);
if (userDailyLinkClickOld == null || userDailyLinkClickOld.IID <= 0)
{
UserDailyLinkClick userDailyLinkClick = new UserDailyLinkClick();
userDailyLinkClick.UserID = CurrentUserID;
userDailyLinkClick.ClickCount = 1;
userDailyLinkClick.Date = DateTime.Now;
facade.Insert<UserDailyLinkClick>(userDailyLinkClick);
}
else
{
int click = userDailyLinkClickOld.ClickCount;
userDailyLinkClickOld.ClickCount=click+1;
facade.Update<UserDailyLinkClick>(userDailyLinkClickOld);
}
decimal Amount = Convert.ToDecimal(0.05);
decimal sponsorAmount = (Amount * 5) / 100;
decimal actualAmount=Amount-sponsorAmount;
UserBalance userBalanceOld = facade.AdvertiseFacade.GetUserBalanceByUserID(CurrentUserID);
if (userBalanceOld == null)
{
UserBalance userBalance = new UserBalance();
userBalance.Amount = actualAmount;
userBalance.UserID = CurrentUserID;
facade.Insert<UserBalance>(userBalance);
}
else
{
userBalanceOld.Amount = userBalanceOld.Amount + actualAmount;
facade.Update<UserBalance>(userBalanceOld);
}
UserTransactionHistory userTransactionHistory = new UserTransactionHistory();
userTransactionHistory.UserID = CurrentUserID;
userTransactionHistory.UserTransactionTypeID = Convert.ToInt32(EnumHelper.UserTransactionType.Click);
userTransactionHistory.Amount = actualAmount ;
userTransactionHistory.ActualAmount = Amount;
userTransactionHistory.Date = DateTime.Now;
userTransactionHistory.Description = "You have received $"+actualAmount.ToString()+" for clicking a advetrisement";
userTransactionHistory.Status = 1;
userTransactionHistory.TAXAmount = 0;
Guid TransactionKey = System.Guid.NewGuid();
userTransactionHistory.TransactionKey = TransactionKey;
facade.Insert<UserTransactionHistory>(userTransactionHistory);
SystemUser user = facade.TanviFacade.GetSystemUserById(CurrentUserID);
UserTransactionHistory userTransactionHistory2 = new UserTransactionHistory();
userTransactionHistory2.UserID = user.SponsorID.Value;
userTransactionHistory2.UserTransactionTypeID = Convert.ToInt32(EnumHelper.UserTransactionType.Sponsor);
userTransactionHistory2.Amount = sponsorAmount;
userTransactionHistory2.ActualAmount = sponsorAmount;
userTransactionHistory2.Date = DateTime.Now;
userTransactionHistory2.Description = "You have received $" + sponsorAmount.ToString() + " sponsor amount for clicking a advetrisement of your sponsored user";
userTransactionHistory2.Status = 1;
userTransactionHistory2.TAXAmount = 0;
userTransactionHistory2.TransactionKey = TransactionKey;
facade.Insert<UserTransactionHistory>(userTransactionHistory2);
UserBalance sponsorUserBalance = facade.AdvertiseFacade.GetUserBalanceByUserID(user.SponsorID.Value);
if (sponsorUserBalance == null)
{
sponsorUserBalance = new UserBalance();
sponsorUserBalance.Amount = sponsorAmount;
sponsorUserBalance.UserID = user.SponsorID.Value;
facade.Insert<UserBalance>(sponsorUserBalance);
}
else
{
sponsorUserBalance.Amount = sponsorUserBalance.Amount + sponsorAmount;
facade.Update<UserBalance>(sponsorUserBalance);
}
Label1.Text = "Done";
Timer1.Enabled = false;
Response.Redirect("~/Advertise/ClickAdd.aspx");
}
}
}
}
