public List <GeneralCodeFileLevel> GetGeneralCodeFileLevelByFileType(Int32 fileTypeCode_PK, Int32 companyCode_PK)
{
List <GeneralCodeFileLevel> listGeneralCodeFileLevel = new List <GeneralCodeFileLevel>();
GeneralCodeFileLevel objGeneralCodeFileLevel;
string vComTxt = @"SELECT [LevelCode]
,[UserCode]
,[ActionType]
,[ActionDate]
,[LevelId]
,[LevelName]
,[FileTypeCode]
,[CompanyCode]
,[FileIdStartFrom]
,[ModuleCode]
FROM [dbo].[General_CodeFileLevel]
where FileTypeCode=" + fileTypeCode_PK + " And CompanyCode = " + companyCode_PK + "";
SqlConnection connection = _supplierDbContext.GetConn();
connection.Open();
SqlDataReader dr;
SqlCommand objDbCommand = new SqlCommand(vComTxt, connection);
dr = objDbCommand.ExecuteReader();
while (dr.Read())
{
objGeneralCodeFileLevel = new GeneralCodeFileLevel();
objGeneralCodeFileLevel.LevelCode_PK = Convert.ToInt32(dr["LevelCode"].ToString());
objGeneralCodeFileLevel.UserCode = dr["UserCode"].ToString();
objGeneralCodeFileLevel.ActionType = dr["ActionType"].ToString();
objGeneralCodeFileLevel.LevelId = dr["LevelId"].ToString();
objGeneralCodeFileLevel.LevelName = dr["LevelName"].ToString();
objGeneralCodeFileLevel.FileTypeCode = Convert.ToInt32(dr["FileTypeCode"].ToString());
if (!string.IsNullOrEmpty(dr["CompanyCode"].ToString()))
{
objGeneralCodeFileLevel.CompanyCode_FK = Convert.ToUInt16(dr["CompanyCode"].ToString());
}
objGeneralCodeFileLevel.FileIdStartFrom = dr["FileIdStartFrom"].ToString();
objGeneralCodeFileLevel.ModuleCode = dr["ModuleCode"].ToString();
listGeneralCodeFileLevel.Add(objGeneralCodeFileLevel);
}
return(listGeneralCodeFileLevel);
}
public IActionResult SaveGeneralCodeFileLevel(GeneralCodeFileLevel objGeneralCodeFileLevel)
{
objGeneralCodeFileLevel.ActionDate = CommonValidation.FormatDate(DateTime.Today.ToString("dd-MM-yyyy"), "yyyy-mm-dd", "dd-mm-yyyy");
if (objGeneralCodeFileLevel.LevelCode_PK == 0)
{
objGeneralCodeFileLevel.IsNew = true;
}
else
{
objGeneralCodeFileLevel.IsNew = false;
}
string Vmsg = _ICommonGeneralCodeFileLevel.SaveGeneralCodeFileLevel(objGeneralCodeFileLevel);
return(Ok(new
{
message = Vmsg
}));
}
public string SaveGeneralCodeFileLevel(GeneralCodeFileLevel objGeneralCodeFileLevel)
{
objGeneralCodeFileLevel.TableNm_TBL = GeneralCodeFileType_TBL;
ArrayList vQueryList = new ArrayList();
string vOut = "Exception Occured !";
if (objGeneralCodeFileLevel.IsNew)
{
string vComTxt = @"select (isnull(max(LevelCode),0) +1) as LevelCode_PK from General_CodeFileLevel";
SqlConnection connections = _supplierDbContext.GetConn();
connections.Open();
SqlDataReader dr;
SqlCommand objDbCommand = new SqlCommand(vComTxt, connections);
dr = objDbCommand.ExecuteReader();
while (dr.Read())
{
objGeneralCodeFileLevel.LevelCode_PK = Convert.ToInt32(dr["LevelCode_PK"].ToString());
}
objDbCommand.Dispose();
connections.Close();
vQueryList.Add(GetQuery(objGeneralCodeFileLevel));
int vResult = 0;
SqlConnection connection = _supplierDbContext.GetConn();
connection.Open();
using (SqlTransaction trans = connection.BeginTransaction())
{
try
{
using (SqlCommand command = _supplierDbContext.GetCommand())
{
foreach (string obj_temp in vQueryList)
{
command.CommandText = obj_temp;
command.Transaction = trans;
vResult = command.ExecuteNonQuery();
}
if (vResult > 0)
{
trans.Commit();
vOut = "Code File Level Saved Successfully";
}
else
{
vOut = "Level Code is duplicate";
}
}
}
catch (DbException ex)
{
trans.Rollback();
throw ex;
}
finally
{
connection.Close();
}
}
}
return(vOut);
}
