public static A2ZLOCATIONDTO GetLocationInformation(Int16 locationCode)
{
DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery(
"SELECT * FROM A2ZLOCATION WHERE LocationCode = " + locationCode, "A2ZHRMCUS");
var p = new A2ZLOCATIONDTO();
if (dt.Rows.Count > 0)
{
p.ID = Converter.GetSmallInteger(dt.Rows[0]["ID"]);
p.LocationCode = Converter.GetSmallInteger(dt.Rows[0]["LocationCode"]);
p.LocationName = Converter.GetString(dt.Rows[0]["LocationName"]);
p.LocationFlag = Converter.GetSmallInteger(dt.Rows[0]["LocationFlag"]);
p.LocationType = Converter.GetSmallInteger(dt.Rows[0]["LocationType"]);
p.LocationStatus = Converter.GetSmallInteger(dt.Rows[0]["LocationStatus"]);
p.UserId = Converter.GetSmallInteger(dt.Rows[0]["UserId"]);
p.CreateDate = Converter.GetDateTime(dt.Rows[0]["CreateDate"]);
return(p);
}
p.LocationCode = 0;
return(p);
}
public static int InsertLocationInformation(A2ZLOCATIONDTO dto)
{
int nSrlNo = GetLastSerialNo();
int rowEffect = 0;
string strQuery = "INSERT INTO A2ZLOCATION(LocationCode,LocationName,UserId)VALUES('" + nSrlNo + "','" + dto.LocationName + "','" + dto.UserId + "')";
rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZHRMCUS"));
if (rowEffect == 0)
{
return(0);
}
return(nSrlNo);
}
public static int UpdateLocationInformation(A2ZLOCATIONDTO dto)
{
string strQuery = "UPDATE A2ZLOCATION SET LocationName ='" + dto.LocationName + "',UserId='" + dto.UserId + "' WHERE LocationCode='" + dto.LocationCode + "'";
return(Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZERPHR")));
}