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