/* public int DL_UpdateStateMaster(ML_State_Master objML_Default) * { * SqlParameter[] par ={new SqlParameter("@UserName", objML_Default.UserName) * * }; * return SqlHelper.ExecuteNonQuery(con, "OSP_UserDetailNameWise", par).Tables[0]; * * }*/ public int DL_InsStateMaster(ML_State_Master objML_Default) { SqlParameter[] par = { new SqlParameter("@stateId", objML_Default.StateId), new SqlParameter("@stateName", objML_Default.StateName), new SqlParameter("@CreatedBy", objML_Default.CreatedBy), new SqlParameter("@ModifyBy", objML_Default.ModifyBy) }; return(SqlHelper.ExecuteNonQuery(con, "OSP_InsState", par)); }
public DataTable DL_EditState(ML_State_Master objML_Default) { SqlParameter[] par = { new SqlParameter("@ID", objML_Default.StateId), }; return(SqlHelper.ExecuteDataset(con, "SPCN_State_Edit", par).Tables[0]); }
public int DL_DeleteState(ML_State_Master objML_Default) { SqlParameter[] par = { new SqlParameter("@ID", objML_Default.StateId), }; return(SqlHelper.ExecuteNonQuery(con, "SPCN_State_Delete", par)); }
public DataTable BL_EditState(ML_State_Master objML_Default) { return(objState.DL_EditState(objML_Default)); }
public int BL_DeleteState(ML_State_Master objML_Default) { return(objState.DL_DeleteState(objML_Default)); }
public int BL_InsStateDetail(ML_State_Master objML_Default) { return(objState.DL_InsStateMaster(objML_Default)); }