internal DataTable LoadHSNSACInfo(HSNSACModel objHSNSACModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPHSNSACMaster";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objHSNSACModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@GoodsServiceInd", objHSNSACModel.GoodsServiceInd);
ClsCon.cmd.Parameters.AddWithValue("@HSNSACCode", objHSNSACModel.HSNSACCode);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtHSNSAC = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtHSNSAC);
dtHSNSAC.TableName = "success";
}
catch (Exception)
{
dtHSNSAC = new DataTable();
dtHSNSAC.TableName = "error";
return(dtHSNSAC);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtHSNSAC);
}
public DataTable UpdateHSNSACInfo(HSNSACModel objHSNSACModel)
{
DataTable dtUpdateHSNSACInfo = objHSNSACDA.UpdateHSNSACInfo(objHSNSACModel);
return(dtUpdateHSNSACInfo);
}
public DataTable LoadHSNSACInfo(HSNSACModel objHSNSACModel)
{
DataTable dtHSNSACInfo = objHSNSACDA.LoadHSNSACInfo(objHSNSACModel);
return(dtHSNSACInfo);
}
