public async Task <ShareConfigDTO> GetShareNameANdcode(string ShareName, string ShareCode, string ConnectionString)
{
ShareConfigDTO ShareConfigDTO = new ShareConfigDTO();
await Task.Run(() =>
{
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "SELECT shareconfigid, sharename, sharecode, companycode, branchcode, series, serieslength, sharenamecode FROM tblmstshareconfig where upper(sharecode)='" + ManageQuote(ShareCode.ToUpper()) + "' and upper(sharename)='" + ManageQuote(ShareName.ToUpper()) + "' and statusid = " + Convert.ToInt32(Status.Active) + ";"))
{
while (dr.Read())
{
ShareConfigDTO.pshareconfigid = Convert.ToInt64(dr["shareconfigid"]);
ShareConfigDTO.psharename = Convert.ToString(dr["sharename"]);
ShareConfigDTO.psharecode = Convert.ToString(dr["sharecode"]);
ShareConfigDTO.pcompanycode = Convert.ToString(dr["companycode"]);
ShareConfigDTO.pbranchcode = Convert.ToString(dr["branchcode"]);
ShareConfigDTO.pseries = Convert.ToString(dr["series"]);
ShareConfigDTO.pserieslength = Convert.ToInt64(dr["serieslength"]);
ShareConfigDTO.psharenamecode = Convert.ToString(dr["sharenamecode"]);
}
}
}
catch (Exception)
{
throw;
}
});
return(ShareConfigDTO);
}
public async Task <IActionResult> GetShareNameAndCodeDetails(string ShareName, string ShareCode)
{
ShareConfigDTO ShareConfigDTO = new ShareConfigDTO();
try
{
ShareConfigDTO = await ObjShareConfig.GetShareNameANdcode(ShareName, ShareCode, Con);
return(ShareConfigDTO != null?Ok(ShareConfigDTO) : (IActionResult)StatusCode(StatusCodes.Status204NoContent));
}
catch (Exception)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
throw;
}
}
public IActionResult SaveShareNameAndCode([FromBody] ShareConfigDTO ShareConfigDTO)
{
try
{
if (ObjShareConfig.SaveShareNameANdcode(ShareConfigDTO, Con))
{
return(Ok(true));
}
else
{
return(StatusCode(StatusCodes.Status304NotModified));
}
}
catch (Exception)
{
return(StatusCode(StatusCodes.Status500InternalServerError));
throw;
}
}
public bool SaveShareNameANdcode(ShareConfigDTO ShareConfigDTO, string ConnectionString)
{
bool Issaved = false;
StringBuilder SbInsert = new StringBuilder();
try
{
con = new NpgsqlConnection(ConnectionString);
if (con.State != ConnectionState.Open)
{
con.Open();
}
trans = con.BeginTransaction();
if (ShareConfigDTO != null)
{
if (string.IsNullOrEmpty(ShareConfigDTO.psharename))
{
ShareConfigDTO.psharename = "";
}
if (string.IsNullOrEmpty(ShareConfigDTO.psharecode))
{
ShareConfigDTO.psharecode = "";
}
if (string.IsNullOrEmpty(ShareConfigDTO.pcompanycode))
{
ShareConfigDTO.pcompanycode = "";
}
if (string.IsNullOrEmpty(ShareConfigDTO.pbranchcode))
{
ShareConfigDTO.pbranchcode = "";
}
if (string.IsNullOrEmpty(ShareConfigDTO.pseries))
{
ShareConfigDTO.pseries = "";
}
if (string.IsNullOrEmpty(ShareConfigDTO.psharenamecode))
{
ShareConfigDTO.psharenamecode = "";
}
if (string.IsNullOrEmpty(ShareConfigDTO.pshareconfigid.ToString()) || ShareConfigDTO.pshareconfigid == 0)
{
SbInsert.Append("INSERT INTO tblmstshareconfig(sharename, sharecode, companycode, branchcode,series, serieslength, sharenamecode, statusid, createdby, createddate) VALUES ('" + ManageQuote(ShareConfigDTO.psharename) + "','" + ManageQuote(ShareConfigDTO.psharecode) + "','" + ManageQuote(ShareConfigDTO.pcompanycode) + "','" + ManageQuote(ShareConfigDTO.pbranchcode) + "','" + ManageQuote(ShareConfigDTO.pseries) + "'," + ShareConfigDTO.pserieslength + ",'" + ManageQuote(ShareConfigDTO.psharenamecode) + "'," + Convert.ToInt32(Status.Active) + "," + ShareConfigDTO.pCreatedby + ",current_timestamp);");
}
else
{
SbInsert.Append("update tblmstshareconfig set sharename='" + ManageQuote(ShareConfigDTO.psharename) + "', sharecode='" + ManageQuote(ShareConfigDTO.psharecode) + "', companycode='" + ManageQuote(ShareConfigDTO.pcompanycode) + "', branchcode='" + ManageQuote(ShareConfigDTO.pbranchcode) + "',series='" + ManageQuote(ShareConfigDTO.pseries) + "', serieslength=" + ShareConfigDTO.pserieslength + ", sharenamecode='" + ManageQuote(ShareConfigDTO.psharenamecode) + "' where shareconfigid=" + ShareConfigDTO.pshareconfigid + ";");
}
}
if (Convert.ToString(SbInsert) != string.Empty)
{
NPGSqlHelper.ExecuteNonQuery(trans, CommandType.Text, SbInsert.ToString());
}
trans.Commit();
Issaved = true;
}
catch (Exception)
{
trans.Rollback();
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Dispose();
con.Close();
con.ClearPool();
trans.Dispose();
}
}
return(Issaved);
}
