public static A2ZALLOWCTRLDTLDTO GetInformation(int AllowCode)
{
DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZALLOWCTRLDTL WHERE AllowCode = '" + AllowCode + "'", "A2ZHRMCUS");
var p = new A2ZALLOWCTRLDTLDTO();
if (dt.Rows.Count > 0)
{
p.ID = Converter.GetInteger(dt.Rows[0]["Id"]);
p.AllowCode = Converter.GetInteger(dt.Rows[0]["AllowCode"]);
p.AllowDesc = Converter.GetString(dt.Rows[0]["AllowDesc"]);
p.BaseGrade = Converter.GetSmallInteger(dt.Rows[0]["BaseGrade"]);
p.BaseGradeDesc = Converter.GetString(dt.Rows[0]["BaseGradeDesc"]);
p.GradeCode = Converter.GetInteger(dt.Rows[0]["GradeCode"]);
p.GradeDesc = Converter.GetString(dt.Rows[0]["GradeDesc"]);
p.DesignationCode = Converter.GetInteger(dt.Rows[0]["DesignationCode"]);
p.DesigDesc = Converter.GetString(dt.Rows[0]["DesigDesc"]);
p.LocationCode = Converter.GetInteger(dt.Rows[0]["LocationCode"]);
p.LocationDesc = Converter.GetString(dt.Rows[0]["LocationDesc"]);
p.ServTypeCode = Converter.GetInteger(dt.Rows[0]["ServTypeCode"]);
p.ServTypeDesc = Converter.GetString(dt.Rows[0]["ServTypeDesc"]);
p.ReligionCode = Converter.GetInteger(dt.Rows[0]["ReligionCode"]);
p.ReligionDesc = Converter.GetString(dt.Rows[0]["ReligionDesc"]);
p.Amount = Converter.GetDecimal(dt.Rows[0]["Amount"]);
p.Status = Converter.GetBoolean(dt.Rows[0]["Status"]);
return(p);
}
p.AllowCode = 0;
return(p);
}
public static int UpdateInformation(A2ZALLOWCTRLDTLDTO dto)
{
int rowEffect = 0;
string strQuery = "UPDATE A2ZALLOWCTRLDTL set BaseGrade='" + dto.BaseGrade + "', BaseGradeDesc='" + dto.BaseGradeDesc + "',GradeCode='" + dto.GradeCode + "', GradeDesc='" + dto.GradeDesc + "', DesignationCode='" + dto.DesignationCode + "',DesigDesc='" + dto.DesigDesc + "', LocationCode='" + dto.LocationCode + "',LocationDesc='" + dto.LocationDesc + "', ServTypeCode='" + dto.ServTypeCode + "',ServTypeDesc='" + dto.ServTypeDesc + "',ReligionCode='" + dto.ReligionCode + "',ReligionDesc='" + dto.ReligionDesc + "', Amount='" + dto.Amount + "', Status='" + dto.Status + "' where Id='" + dto.ID + "'";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHRMCUS"));
if (rowEffect == 0)
{
return(0);
}
else
{
return(1);
}
}
public static int InsertInformation(A2ZALLOWCTRLDTLDTO dto)
{
int rowEffect = 0;
string strQuery = @"INSERT into A2ZALLOWCTRLDTL(AllowCode,AllowDesc,BaseGrade,BaseGradeDesc,GradeCode,GradeDesc,DesignationCode,DesigDesc,LocationCode,LocationDesc,ServTypeCode,ServTypeDesc,ReligionCode,ReligionDesc,Amount,Status)
values('" + dto.AllowCode + "','" + dto.AllowDesc + "','" + dto.BaseGrade + "','" + dto.BaseGradeDesc + "','" + dto.GradeCode + "','" + dto.GradeDesc + "','" + dto.DesignationCode + "','" + dto.DesigDesc + "','" +
dto.LocationCode + "','" + dto.LocationDesc + "','" + dto.ServTypeCode + "','" + dto.ServTypeDesc + "','" + dto.ReligionCode + "','" + dto.ReligionDesc + "','" + dto.Amount + "','" + dto.Status + "')";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHRMCUS"));
if (rowEffect == 0)
{
return(0);
}
else
{
return(1);
}
}
