//Update
public bool UpdateStdNarration(eSunSpeedDomain.StdNarrationMasterModel objSNM)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Vouchertype", objSNM.Vouchertype));
paramCollection.Add(new DBParameter("@Narration", objSNM.Narration));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now));
paramCollection.Add(new DBParameter("@SN_Id", objSNM.SN_Id));
Query = "UPDATE StdNarrationMaster SET [Vouchertype]=@Vouchertype,[Narration]=@Narration,[ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " +
"WHERE SN_Id=@SN_Id;";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
//Save
public bool SaveStdNarration(eSunSpeedDomain.StdNarrationMasterModel objSNM)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Vouchertype", objSNM.Vouchertype));
paramCollection.Add(new DBParameter("@Narration", objSNM.Narration));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
Query = "INSERT INTO StdNarrationMaster(`Vouchertype`,`Narration`,`CreatedBy`) " +
"VALUES(@Vouchertype,@Narration,@CreatedBy)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
