public Boolean updateHSNCode(HSNMapping map)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update ProductHSNMapping set HSNCode='" + map.HSNCode +
"',Status=" + map.Status +
" where RowID=" + map.RowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "ProductHSNMapping", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean insertHSNCOde(HSNMapping map)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into ProductHSNMapping (StockItemID,ModelNo,HSNCode,Status,CreateTime,CreateUser)" +
" values (" +
"'" + map.StockItemID + "'," +
"'" + map.ModelNo + "'," +
"'" + map.HSNCode + "'," +
map.Status + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "ProductHSNMapping", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean validateHSNMapping(HSNMapping map)
{
Boolean status = true;
try
{
if (map.StockItemID.Trim().Length == 0 || map.StockItemID == null)
{
return(false);
}
if (map.HSNCode.Trim().Length == 0 || map.HSNCode == null || Convert.ToInt32(map.HSNCode) == 0)
{
return(false);
}
}
catch (Exception)
{
}
return(status);
}
public List <HSNMapping> getHSNMappingList()
{
HSNMapping map;
List <HSNMapping> mapList = new List <HSNMapping>();
try
{
SqlConnection conn = new SqlConnection(Login.connString);
string query = "select a.StockItemID, b.Name,a.ModelNo,c.ModelName,a.HSNCode," +
"a.Status,a.CreateTime,a.CreateUser,a.RowID " +
"from ProductHSNMapping a left outer join " +
"StockItem b on a.StockItemID = b.StockItemID left outer join " +
"ProductModel c on a.StockItemID = c.StockItemID AND a.ModelNo = c.ModelNo " +
"order by a.StockItemID";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
map = new HSNMapping();
map.StockItemID = reader.GetString(0);
map.StockItemName = reader.GetString(1);
map.ModelNo = reader.IsDBNull(2) ? "NA":reader.GetString(2);
map.ModelName = reader.IsDBNull(3) ? "NA":reader.GetString(3);
map.HSNCode = reader.GetString(4);
map.Status = reader.GetInt32(5);
map.CreateTime = reader.GetDateTime(6);
map.CreateUser = reader.GetString(7);
map.RowID = reader.GetInt32(8);
mapList.Add(map);
}
conn.Close();
}
catch (Exception)
{
MessageBox.Show("Error querying HSNMApping Data");
}
return(mapList);
}