public static string[] GetCompletionList(string prefixText, int count, string contextKey)
{
DMClienCompanyMaster Obj_CCMaster = new DMClienCompanyMaster();
String[] SearchList = Obj_CCMaster.GetSuggestedRecord(prefixText);
return(SearchList);
}
protected void BtnDelete_Click(object sender, EventArgs e)
{
try
{
int DeleteId = 0;
if (ViewState["ITEMINUSEORNOT"] == null)
{
if (ViewState["EditID"] != null)
{
DeleteId = Convert.ToInt32(ViewState["EditID"]);
}
if (DeleteId != 0)
{
Entity_CCMaster.ClientCompanyId = DeleteId;
Entity_CCMaster.DeletedBy = Convert.ToInt32(Session["UserID"]);
Entity_CCMaster.DeletedDate = DateTime.Now;
Entity_CCMaster.IsDelete = true;
int iDelete = Obj_CCMaster.DeleteRecord(ref Entity_CCMaster, out StrError);
if (iDelete > 0)
{
obj_Comman.ShowPopUpMsg("Record Deleted Successfully..!", this.Page);
EmptyFormFields();
EmptyMasterForm();
setInitialRow();
ReportGrid(StrCondition);
}
else
{
obj_Comman.ShowPopUpMsg("Item is used in Transaction, Please delete references from Transaction to perform delete operation...!", this.Page);
}
}
}
else
{
obj_Comman.ShowPopUpMsg("Cant Delete Record.. \nUsed In Further Process..!", this.Page);
}
Entity_CCMaster = null;
Obj_CCMaster = null;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void GETCLIENTPDF(int ClientCompantID, int CompanyID, int WITHREMARK)
{
try
{
DMClienCompanyMaster obj_Template = new DMClienCompanyMaster();
ReportDocument CRpt = new ReportDocument();
DataSet dslogin = new DataSet();
string PDFMaster = string.Empty;
string StrError = string.Empty;
dslogin = obj_Template.GetCCMFORPRINT(ClientCompantID, CompanyID, out StrError);
dslogin.Tables[0].TableName = "CLIENTCOMPAY";
dslogin.Tables[1].TableName = "COMPANY";
//----------------------------Image Print---------------------------------------------------------------
string Image = dslogin.Tables[1].Rows[0]["CLogo"].ToString();
string ImageSign = dslogin.Tables[1].Rows[0]["DigitalSignature"].ToString();
string ImageSign1 = dslogin.Tables[1].Rows[0]["DigitalSignature1"].ToString();
string ImageSign2 = dslogin.Tables[1].Rows[0]["DigitalSignature2"].ToString();
dslogin.Tables[1].Columns.Add("CompanyLogo", System.Type.GetType("System.Byte[]"));
dslogin.Tables[1].Columns.Add("Sign1", System.Type.GetType("System.Byte[]"));
dslogin.Tables[1].Columns.Add("Sign2", System.Type.GetType("System.Byte[]"));
dslogin.Tables[1].Columns.Add("Sign3", System.Type.GetType("System.Byte[]"));
Image = Image.Replace("~", "");
Image = Image.Replace("/", "\\");
ImageSign = ImageSign.Replace("~", "");
ImageSign = ImageSign.Replace("/", "\\");
ImageSign1 = ImageSign1.Replace("~", "");
ImageSign1 = ImageSign1.Replace("/", "\\");
ImageSign2 = ImageSign2.Replace("~", "");
ImageSign2 = ImageSign2.Replace("/", "\\");
FileStream fs;
BinaryReader br;
if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + Image))
{
fs = new FileStream(AppDomain.CurrentDomain.BaseDirectory + Image, FileMode.Open);
br = new BinaryReader(fs);
byte[] imgbyte = new byte[fs.Length + 1];
imgbyte = br.ReadBytes(Convert.ToInt32((fs.Length)));
dslogin.Tables[1].Rows[0]["CompanyLogo"] = imgbyte;
dslogin.Tables[1].Rows[dslogin.Tables[1].Rows.Count - 1]["CompanyLogo"] = imgbyte;
br.Close();
fs.Close();
}
FileStream fss1;
BinaryReader brs1;
if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + ImageSign))
{
fss1 = new FileStream(AppDomain.CurrentDomain.BaseDirectory + ImageSign, FileMode.Open);
brs1 = new BinaryReader(fss1);
byte[] imgbyte1 = new byte[fss1.Length + 1];
imgbyte1 = brs1.ReadBytes(Convert.ToInt32((fss1.Length)));
dslogin.Tables[1].Rows[0]["Sign1"] = imgbyte1;
dslogin.Tables[1].Rows[dslogin.Tables[1].Rows.Count - 1]["Sign1"] = imgbyte1;
brs1.Close();
fss1.Close();
}
FileStream fss2;
BinaryReader brs2;
if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + ImageSign1))
{
fss2 = new FileStream(AppDomain.CurrentDomain.BaseDirectory + ImageSign1, FileMode.Open);
brs2 = new BinaryReader(fss2);
byte[] imgbyte2 = new byte[fss2.Length + 1];
imgbyte2 = brs2.ReadBytes(Convert.ToInt32((fss2.Length)));
dslogin.Tables[1].Rows[0]["Sign2"] = imgbyte2;
dslogin.Tables[1].Rows[dslogin.Tables[1].Rows.Count - 1]["Sign2"] = imgbyte2;
brs2.Close();
fss2.Close();
}
FileStream fss3;
BinaryReader brs3;
if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + ImageSign2))
{
fss3 = new FileStream(AppDomain.CurrentDomain.BaseDirectory + ImageSign2, FileMode.Open);
brs3 = new BinaryReader(fss3);
byte[] imgbyte3 = new byte[fss3.Length + 1];
imgbyte3 = brs3.ReadBytes(Convert.ToInt32((fss3.Length)));
dslogin.Tables[1].Rows[0]["Sign3"] = imgbyte3;
dslogin.Tables[1].Rows[dslogin.Tables[1].Rows.Count - 1]["Sign3"] = imgbyte3;
brs3.Close();
fss3.Close();
}
//-------------------------------------------------------------------------------------------
if (WITHREMARK == 0)
{
CRpt.Load(Server.MapPath("~/CrystalPrint/ClientCompanyPrint.rpt"));
CRpt.SetDataSource(dslogin);
string DATE = DateTime.Now.ToString("dd-MMM-yyyy ss");
PDFMaster = Server.MapPath(@"~/TempFiles/" + "ClientCompay - " + (DATE) + ".pdf");
CRpt.ExportToDisk(ExportFormatType.PortableDocFormat, PDFMaster);
CHKATTACHBROUCHER.Checked = true;
CHKATTACHBROUCHER.Text = "Contact Details";
CHKATTACHBROUCHER.ToolTip = PDFMaster;
iframepdf.Attributes.Add("src", "../TempFiles/" + "ClientCompay - " + (DATE) + ".pdf");
}
else
{
CRpt.Load(Server.MapPath("~/CrystalPrint/ClientCompanyPrintWithRemark.rpt"));
CRpt.SetDataSource(dslogin);
string DATE = DateTime.Now.ToString("dd-MMM-yyyy ss");
PDFMaster = Server.MapPath(@"~/TempFiles/" + "ClientCompayDetails - " + (DATE) + ".pdf");
CRpt.ExportToDisk(ExportFormatType.PortableDocFormat, PDFMaster);
CHKATTACHBROUCHER.Checked = true;
CHKATTACHBROUCHER.Text = "Contact Details";
CHKATTACHBROUCHER.ToolTip = PDFMaster;
iframepdf.Attributes.Add("src", "../TempFiles/" + "ClientCompayDetails - " + (DATE) + ".pdf");
}
}
catch (Exception ex)
{
}
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
int UpdateRow = 0, UpdateRowDtls = 0, UpdateRow1 = 0, UpdateUnitCal = 0;
string StrError = "";
try
{
if (ViewState["EditID"] != null)
{
Entity_CCMaster.ClientCompanyId = Convert.ToInt32(ViewState["EditID"]);
}
Entity_CCMaster.CompanyName = TxtCompanyName.Text;
Entity_CCMaster.SupplierFor = TxtSupplierFor.Text;
Entity_CCMaster.Address = TxtAddress.Text;
Entity_CCMaster.WebUrl = TxtWebsite.Text;
Entity_CCMaster.Remark = TxtRemark.Text;
Entity_CCMaster.UpdatedBy = Convert.ToInt32(Session["UserId"]);
Entity_CCMaster.UpdatedDate = DateTime.Now;
UpdateRow = Obj_CCMaster.UpdateRecord(ref Entity_CCMaster, out StrError);
if (UpdateRow > 0)
{
if (ViewState["CurrentTable"] != null)
{
DataTable dtInsert = new DataTable();
dtInsert = (DataTable)ViewState["CurrentTable"];
for (int i = 0; i < dtInsert.Rows.Count; i++)
{
//Entity_CCMaster.PersonId = Convert.ToInt32(dtInsert.Rows[i]["#"].ToString());
Entity_CCMaster.ClientCompanyId = Convert.ToInt32(ViewState["EditID"]);
Entity_CCMaster.PersonName = dtInsert.Rows[i]["PersonName"].ToString();
Entity_CCMaster.Designation = dtInsert.Rows[i]["Designation"].ToString();
Entity_CCMaster.ContactNo1 = dtInsert.Rows[i]["ContactNo1"].ToString();
Entity_CCMaster.ContactNo2 = dtInsert.Rows[i]["ContactNo2"].ToString();
Entity_CCMaster.EmailId1 = dtInsert.Rows[i]["EmailId1"].ToString();
Entity_CCMaster.EmailId2 = dtInsert.Rows[i]["EmailId2"].ToString();
Entity_CCMaster.Note = dtInsert.Rows[i]["Note"].ToString();
UpdateRowDtls = Obj_CCMaster.InsertDertailsRecord(ref Entity_CCMaster, StrError);
}
}
//if (ViewState["CurrentTableSize"] != null)
//{
// DataTable dtInsert = new DataTable();
// dtInsert = (DataTable)ViewState["CurrentTableSize"];
// for (int i = 0; i < dtInsert.Rows.Count; i++)
// {
// //Entity_ItemMaster.ItemId = Convert.ToInt32(ViewState["EditID"]);
// //Entity_ItemMaster.SupplierId = Convert.ToInt32(dtInsert.Rows[i]["SizeId"].ToString());
// //UpdateRowDtls = Obj_ItemMaster.InsertDetailsSizeRecord(ref Entity_ItemMaster, out StrError);
// }
//}
}
if (UpdateRow > 0)
{
obj_Comman.ShowPopUpMsg("Record Updated Successfully", this.Page);
EmptyFormFields();
EmptyMasterForm();
setInitialRow();
ReportGrid(StrCondition);
Entity_CCMaster = null;
Obj_CCMaster = null;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}