public int InsertDetailsRecord(ref ClientCompMaster Entity_Call, out string strError)
{
int iInsert = 0;
strError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter(ClientCompMaster._Action, SqlDbType.BigInt);
SqlParameter pPersonId = new SqlParameter(ClientCompMaster._PersonId, SqlDbType.BigInt);
SqlParameter pClientCompanyId = new SqlParameter(ClientCompMaster._ClienCompanyId, SqlDbType.BigInt);
SqlParameter pPersonName = new SqlParameter(ClientCompMaster._PersonName, SqlDbType.NVarChar);
SqlParameter pDesignation = new SqlParameter(ClientCompMaster._Designation, SqlDbType.NVarChar);
SqlParameter pContactNo1 = new SqlParameter(ClientCompMaster._ContactNo1, SqlDbType.NVarChar);
SqlParameter pContactNo2 = new SqlParameter(ClientCompMaster._ContactNo2, SqlDbType.NVarChar);
SqlParameter pEmailId1 = new SqlParameter(ClientCompMaster._EmailId1, SqlDbType.NVarChar);
SqlParameter pEmailId2 = new SqlParameter(ClientCompMaster._EmailId2, SqlDbType.NVarChar);
SqlParameter pNote = new SqlParameter(ClientCompMaster._Note, SqlDbType.NVarChar);
pAction.Value = 8;
pPersonId.Value = Entity_Call.PersonId;
pClientCompanyId.Value = Entity_Call.ClientCompanyId;
pPersonName.Value = Entity_Call.PersonName;
pDesignation.Value = Entity_Call.Designation;
pContactNo1.Value = Entity_Call.ContactNo1;
pContactNo2.Value = Entity_Call.ContactNo2;
pEmailId1.Value = Entity_Call.EmailId1;
pEmailId2.Value = Entity_Call.EmailId2;
pNote.Value = Entity_Call.Note;
SqlParameter[] param = new SqlParameter[] { pAction, pPersonId, pClientCompanyId, pPersonName,
pDesignation, pContactNo1, pContactNo2,
pEmailId1, pEmailId2, pNote };
Open(CONNECTION_STRING);
BeginTransaction();
iInsert = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, ClientCompMaster.SP_ClientCompanyMaster, param);
if (iInsert > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
strError = ex.Message;
}
finally
{
Close();
}
return(iInsert);
}
public int UpdateRecord(ref ClientCompMaster Entity_Call, out string strError)
{
int iInsert = 0;
strError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter(ClientCompMaster._Action, SqlDbType.BigInt);
SqlParameter pClientCompanyId = new SqlParameter(ClientCompMaster._ClienCompanyId, SqlDbType.BigInt);
SqlParameter pCompanyName = new SqlParameter(ClientCompMaster._CompanyName, SqlDbType.NVarChar);
SqlParameter pSupplierFor = new SqlParameter(ClientCompMaster._SuplierFor, SqlDbType.NVarChar);
SqlParameter pAddress = new SqlParameter(ClientCompMaster._Address, SqlDbType.NVarChar);
SqlParameter pWebUrl = new SqlParameter(ClientCompMaster._WebUrl, SqlDbType.NVarChar);
SqlParameter pRemark = new SqlParameter(ClientCompMaster._Remark, SqlDbType.NVarChar);
SqlParameter pUpdatedBy = new SqlParameter(ClientCompMaster._UpdatedBy, SqlDbType.BigInt);
SqlParameter pUpdatedDate = new SqlParameter(ClientCompMaster._UpdatedDate, SqlDbType.DateTime);
pAction.Value = 6;
pClientCompanyId.Value = Entity_Call.ClientCompanyId;
pCompanyName.Value = Entity_Call.CompanyName;
pSupplierFor.Value = Entity_Call.SupplierFor;
pAddress.Value = Entity_Call.Address;
pWebUrl.Value = Entity_Call.WebUrl;
pRemark.Value = Entity_Call.Remark;
pUpdatedBy.Value = Entity_Call.UpdatedBy;
pUpdatedDate.Value = Entity_Call.UpdatedDate;
SqlParameter[] param = new SqlParameter[] { pAction, pClientCompanyId, pCompanyName, pSupplierFor, pAddress, pWebUrl,
pRemark, pUpdatedBy, pUpdatedDate };
Open(CONNECTION_STRING);
BeginTransaction();
iInsert = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, ClientCompMaster.SP_ClientCompanyMaster, param);
if (iInsert > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
strError = ex.Message;
}
return(iInsert);
}
public int InsertRecord(ref ClientCompMaster Entity_Call, string StrError)
{
int iInsert = 0;
StrError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter(ClientCompMaster._Action, SqlDbType.BigInt);
SqlParameter pCompanyName = new SqlParameter(ClientCompMaster._CompanyName, SqlDbType.NVarChar);
SqlParameter pSupplierFor = new SqlParameter(ClientCompMaster._SuplierFor, SqlDbType.NVarChar);
SqlParameter pAddress = new SqlParameter(ClientCompMaster._Address, SqlDbType.NVarChar);
SqlParameter pWebUrl = new SqlParameter(ClientCompMaster._WebUrl, SqlDbType.NVarChar);
SqlParameter pRemark = new SqlParameter(ClientCompMaster._Remark, SqlDbType.NVarChar);
SqlParameter pCreatedBy = new SqlParameter(ClientCompMaster._CreatedBy, SqlDbType.BigInt);
SqlParameter pCreatedDate = new SqlParameter(ClientCompMaster._CreatedDate, SqlDbType.DateTime);
SqlParameter pIsDelete = new SqlParameter(ClientCompMaster._IsDelete, SqlDbType.Bit);
pAction.Value = 1;
pCompanyName.Value = Entity_Call.CompanyName;
pSupplierFor.Value = Entity_Call.SupplierFor;
pAddress.Value = Entity_Call.Address;
pWebUrl.Value = Entity_Call.WebUrl;
pRemark.Value = Entity_Call.Remark;
pCreatedBy.Value = Entity_Call.CreatedBy;
pCreatedDate.Value = Entity_Call.CreatedDate;
pIsDelete.Value = Entity_Call.IsDelete;
SqlParameter[] param = new SqlParameter[] { pAction, pCompanyName, pSupplierFor, pAddress, pWebUrl,
pRemark, pIsDelete, pCreatedBy, pCreatedDate };
//pPersonName,pDesignation,pContactNo1,pContactNo2,
// pEmailId1,pEmailId2,pNote
Open(CONNECTION_STRING);
BeginTransaction();
iInsert = SQLHelper.ExecuteScalar(_Connection, _Transaction, CommandType.StoredProcedure, ClientCompMaster.SP_ClientCompanyMaster, param);
if (iInsert > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
StrError = ex.Message;
}
return(iInsert);
}
public int DeleteRecord(ref ClientCompMaster Entity_Call, out string strError)
{
int iDelete = 0;
strError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter(ClientCompMaster._Action, SqlDbType.BigInt);
SqlParameter pClienCompanyId = new SqlParameter(ClientCompMaster._ClienCompanyId, SqlDbType.BigInt);
SqlParameter pDeletedBy = new SqlParameter(ClientCompMaster._DeletedBy, SqlDbType.BigInt);
SqlParameter pDeletedDate = new SqlParameter(ClientCompMaster._DeletedDate, SqlDbType.DateTime);
SqlParameter pIsDeleted = new SqlParameter(ClientCompMaster._IsDelete, SqlDbType.Bit);
pAction.Value = 5;
pClienCompanyId.Value = Entity_Call.ClientCompanyId;
pDeletedBy.Value = Entity_Call.DeletedBy;
pDeletedDate.Value = Entity_Call.DeletedDate;
pIsDeleted.Value = Entity_Call.IsDelete;
SqlParameter[] Param = new SqlParameter[] { pAction, pClienCompanyId, pDeletedBy, pDeletedDate, pIsDeleted };
Open(CONNECTION_STRING);
BeginTransaction();
iDelete = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, ClientCompMaster.SP_ClientCompanyMaster, Param);
if (iDelete > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
strError = ex.Message;
}
finally
{
Close();
}
return(iDelete);
}
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);
}
}
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);
}
}
