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); } }