public static int InsertInformation(A2ZALLOWANCEDTO objIds)
{
int rowwEffect = 0;
string strQuery = "INSERT INTO A2ZALLOWANCE(Code,Description,Status) VALUES ('" + objIds.Code + "','" + objIds.Description + "','" + objIds.Status + "')";
rowwEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHRMCUS"));
return(rowwEffect);
}
public static A2ZALLOWANCEDTO GetInformation(int AlwCode)
{
DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZALLOWANCE WHERE Code = " + AlwCode, "A2ZHRMCUS");
var p = new A2ZALLOWANCEDTO();
if (dt.Rows.Count > 0)
{
p.Id = Converter.GetInteger(dt.Rows[0]["ID"]);
p.Code = Converter.GetInteger(dt.Rows[0]["Code"]);
p.Description = Converter.GetString(dt.Rows[0]["Description"]);
p.Status = Converter.GetBoolean(dt.Rows[0]["Status"]);
return(p);
}
p.Code = 0;
return(p);
}
public static int UpdateRepColumn(A2ZALLOWANCEDTO dto)
{
string strQuery = "UPDATE A2ZALLOWANCE SET RepColumn = '" + dto.RepColumn + "' WHERE Code ='" + dto.Code + "'";
return(Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHRMCUS")));
}
public static int UpdateInformation(A2ZALLOWANCEDTO dto)
{
string strQuery = "UPDATE A2ZALLOWANCE SET Description = '" + dto.Description + "', Status='" + dto.Status + "' WHERE Code ='" + dto.Code + "'";
return(Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHRMCUS")));
}