//UPDATE public bool UpdateCCGM(eSunSpeedDomain.CostCentreGroupModel objCCG) { string Query = string.Empty; bool isUpdated = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@GroupName", objCCG.GroupName)); paramCollection.Add(new DBParameter("@Alias", objCCG.Alias)); paramCollection.Add(new DBParameter("@PrimaryGroup", objCCG.PrimaryGroup, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@underGroup", objCCG.underGroup)); paramCollection.Add(new DBParameter("@ModifiedBy", objCCG.ModifiedBy)); paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@CCG_ID", objCCG.CCG_ID)); Query = "UPDATE CostCentreGroupMaster SET GroupName=@GroupName,Alias=@Alias,`PrimaryGroup`=@PrimaryGroup,underGroup=@underGroup,ModifiedBy=@ModifiedBy,ModifiedDate=@ModifiedDate " + "WHERE CCG_ID=@CCG_ID"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { isUpdated = true; } } catch (Exception ex) { isUpdated = false; throw ex; } return(isUpdated); }
//Save public bool SaveCCG(eSunSpeedDomain.CostCentreGroupModel ObjCCG) { string Query = string.Empty; bool isSaved = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@GroupName", ObjCCG.GroupName)); paramCollection.Add(new DBParameter("@Alias", ObjCCG.Alias)); paramCollection.Add(new DBParameter("@PrimaryGroup", ObjCCG.PrimaryGroup, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@underGroup", ObjCCG.underGroup)); paramCollection.Add(new DBParameter("@CreatedBy", ObjCCG.CreatedBy)); paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime)); Query = "INSERT INTO CostCentreGroupMaster(`GroupName`,`Alias`,`PrimaryGroup`,`underGroup`,`CreatedBy`,`CreatedDate`)" + "VALUES(@GroupName,@Alias,@PrimaryGroup,@underGroup,@CreatedBy,@CreatedDate)"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { isSaved = true; } } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }