void lastBlock_EntSelectedImage(int ImgTag)
{
try
{
ImageArry = lstImage[ImgTag];
curImg = ImgTag;
delSetImage(ImageArry);
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "lastBlock_EntSelectedImage", "ctlImageSharing.xaml.cs");
}
}
public static DataSet GetAllCampaign()
{
try
{
//Get campaign data using rptCountByState_GetAllCampaign from rptCountByState.DataAccess
return(new rptCountByState.DataAccess.ClsRptCountByStateDataService().rptCountByState_GetAllCampaign());
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "GetAllCampaign()", "ClsRptCountByState.cs");
return(null);
}
}
public int Save(IDbTransaction txn)
{
try
{
//Function for saving data in group
return(new Group.DataAccess.ClsGroupDataService(txn).Group_Save(ref _ID, _GroupName, _IsActive, _CreatedBy, _Description));
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "Save", "ClsGroup.cs");
return(0);
}
}
protected DataSet ExecuteDataSet(string cmdText, CommandType cmdType, params IDataParameter[] procParams)
{
try
{
SqlCommand cmd;
return(ExecuteDataSet(out cmd, cmdText, cmdType, procParams));
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "ExecuteDataSet(string,CommandType...)", "clsdataservicebase.cs");
return(null);
}
}
public void Dispose()
{
try
{
Dispose(true);
GC.SuppressFinalize(this);
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "Dispose()", "Controls\\VMuktiGrid\\Buddy\\ctlPodBuddyList.xaml.cs");
}
}
public DataTable Permissions_Get(Int64 RoleID)
{
try
{
DataSet ds = ExecuteDataSet("Select * from vModulePermission where RoleID ='" + RoleID + "';", CommandType.Text, null);
return(ds.Tables[0]);
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "Permissions_Get", "ClsRoleDataService.cs");
return(null);
}
}
public void Group_Delete(int ID)
{
try
{
//Delete data from Group as well as UserGroup
ExecuteNonQuery("spDGroup", CreateParameter("@pID", SqlDbType.Int, ID));
ExecuteNonQuery("spDUserGroup", CreateParameter("@pID", SqlDbType.Int, ID));
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "Group_Delete", "ClsGroupDataService.cs");
}
}
public void RemovePageAllocation(int intPageId, int intUserId)
{
try
{
ExecuteDataSet("spDPageAllocation", CommandType.StoredProcedure,
CreateParameter("@pID", SqlDbType.BigInt, intPageId),
CreateParameter("@uID", SqlDbType.BigInt, intUserId));
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "RemovePageAllocation", "ClsPageDataService.cs");
}
}
public int GetMaxLocationID()
{
try
{
DataSet ds = ExecuteDataSet("Select IsNull(Max(ID),0)+1 from Location;", CommandType.Text, null);
return(int.Parse(ds.Tables[0].Rows[0][0].ToString()));
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "GetMaxLocationID()", "ClsImportLeadsDataService.cs");
return(0);
}
}
void btnCancel_Click(object sender, RoutedEventArgs e)
{
try
{
funSetGrid();
varState = 0;
FncClearAll();
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "btnCancel_Click", "CtlScript.xaml.cs");
}
}
public DataSet GetPageAllocated(int intUserId)
{
try
{
return(ExecuteDataSet("spGetUsersPageAllocated", CommandType.StoredProcedure,
CreateParameter("@pUserID", SqlDbType.BigInt, intUserId)));
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "GetPageAllocated", "ClsPageDataService.cs");
return(null);
}
}
private void btnBack_Click(object sender, RoutedEventArgs e)
{
try
{
cnvCanavas3.Visibility = Visibility.Hidden;
cnvCanavas1.Visibility = Visibility.Visible;
lstFill.Visibility = Visibility.Hidden;
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "btnBack_Click()", "ctlFilterDesinger.xaml.cs");
}
}
void btnCancel_Click(object sender, RoutedEventArgs e)
{
try
{
FncClearAll();
funSetGrid();
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "btnCancel_Click", "ctlCalllingList.xaml.cs");
}
}
//public static StringBuilder sb1;
//public static StringBuilder CreateTressInfo()
//{
//StringBuilder sb = new StringBuilder();
//sb.Append("User Is : " + VMuktiAPI.VMuktiInfo.CurrentPeer.DisplayName);
//sb.AppendLine();
//sb.Append("Peer Type is : " + VMuktiAPI.VMuktiInfo.CurrentPeer.CurrPeerType.ToString());
//sb.AppendLine();
//sb.Append("User's SuperNode is : " + VMuktiAPI.VMuktiInfo.CurrentPeer.SuperNodeIP);
//sb.AppendLine();
//sb.Append("User's Machine Ip Address : " + VMuktiAPI.GetIPAddress.ClsGetIP4Address.GetIP4Address());
//sb.AppendLine();
//sb.AppendLine("----------------------------------------------------------------------------------------");
//return sb;
//}
public ctlRptHistory(ModulePermissions[] MyPermissions)
{
try
{
InitializeComponent();
this.Loaded += new RoutedEventHandler(ctlRptRemainingLeads_Loaded);
this.Loaded += new RoutedEventHandler(ctlRptHistory_Loaded);
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "ctlRptHistory()", "ctlRptHistory.xaml.cs");
}
}
public void CallingList_Delete(Int64 ID)
{
try
{
ExecuteNonQuery("spDCallingList", CreateParameter("@pID", SqlDbType.BigInt, ID));
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "CallingList_Delete", "ClsCallingListDataService.cs");
}
}
//public DataSet User_GetByID(int ID)
//{
// return ExecuteDataSet("spGUserInfoPayroll", CommandType.StoredProcedure, CreateParameter("@pID", SqlDbType.Int, ID));
//}
//public void User_Save(ref int ID, string displayame,int roleID,string firstName,string lastName,string eMail,string password,bool isActive,int byUserId,float ratePerHour,float overTimeRate,float doubleRatePerHour,float doubleOverTimeRate )
//{
// SqlCommand cmd;
// ExecuteNonQuery(out cmd, "spAEUserInfoPayroll",
// CreateParameter("@pID", SqlDbType.Int, ID),
// CreateParameter("@pDisplayName", SqlDbType.NVarChar, displayame, 100),
// CreateParameter("@pRoleID", SqlDbType.BigInt, roleID),
// CreateParameter("@pFirstName", SqlDbType.NVarChar, firstName, 50),
// CreateParameter("@pLastName", SqlDbType.NVarChar, lastName, 50),
// CreateParameter("@pEMail", SqlDbType.NVarChar, eMail, 256),
// CreateParameter("@pPassword", SqlDbType.NVarChar, password, 50),
// CreateParameter("@pIsActive", SqlDbType.Bit, isActive),
// CreateParameter("@pByUserID", SqlDbType.BigInt, byUserId),
// CreateParameter("@pRatePerHour", SqlDbType.Float, ratePerHour),
// CreateParameter("@pOverTimeRate", SqlDbType.Float, overTimeRate),
// CreateParameter("@pDoubleRatePerHour", SqlDbType.Float, doubleRatePerHour),
// CreateParameter("@pDoubleOverTimeRate", SqlDbType.Float, doubleOverTimeRate));
// cmd.Dispose();
//}
//public void User_Delete(int ID)
//{
// ExecuteNonQuery("spDUserInfoPayroll", CreateParameter("@pID", SqlDbType.Int, ID));
//}
public DataSet GetLocationID(Int64 Zip)
{
try
{
return(ExecuteDataSet("select Location.ID as ID,Location.TimeZoneID as TimeZoneID,Location.CountryID as CountryID,Location.StateID as StateID,Location.AreaCodeID as AreaCodeID,Location.ZipCodeID as ZipeCodeID,Zipcode.ZipCode as ZipCode from Location, Zipcode where Location.ZipCodeID=Zipcode.ID and Zipcode.ZipCode=" + Zip + ";", CommandType.Text, null));
//return ExecuteDataSet("select * from Location where ZipCodeID=" + Zip + ";", CommandType.Text, null);
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "GetLocationID()", "ClsImportLeadsDataService.cs");
return(null);
}
}
public DataSet CallingList_GetByID(Int64 ID)
{
try
{
return ExecuteDataSet("spGCallingList", CommandType.StoredProcedure, CreateParameter("@pID", SqlDbType.BigInt, ID));
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "CallingList_GetByID", "ClsCalllingListDataService.cs");
return null;
}
}
public int GetZipCodeID(Int64 finalzipcode)
{
try
{
DataSet ds = ExecuteDataSet("Select ID from Zipcode where ZipCode=" + finalzipcode + ";", CommandType.Text, null);
return(int.Parse(ds.Tables[0].Rows[0][0].ToString()));
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "GetZipCodeID()", "ClsImportLeadsDataService.cs");
return(0);
}
}
public DataSet Group_GetAll()
{
try
{
return ExecuteDataSet("Select * from vGroup;", CommandType.Text, null);
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "Group_GetAll", "ClsGroupDataService.cs");
return null;
}
}
public DataSet Filter_GetAll(string Condition)
{
try
{
return(ExecuteDataSet("select Treatment.ID,TreatmentName as FilterName,Description,Type,TreatmentCondition.ID as TreatmentCondID,FieldID,Operator,FieldValues from Treatment,TreatmentCondition where Treatment.IsDeleted = 0 and Treatment.Type = 'Filter' and Treatment.Id = TreatmentCondition.TreatmentID and Treatment.ID in (" + Condition + ");", CommandType.Text, null));
//return ExecuteDataSet("select Treatment.ID,TreatmentName as FilterName,Description,Type,TreatmentConditionNew.ID as TreatmentCondID,FieldID,Operator,FieldValues from Treatment,TreatmentConditionNew where Treatment.IsDeleted = 0 and Treatment.Type = 'Filter' and Treatment.Id = TreatmentConditionNew.TreatmentID;", CommandType.Text, null);
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "Filter_GetAll()", "ClsImportLeadsDataService.cs");
return(null);
}
}
public void FncOpenPane()
{
try
{
blnFirstClick = true;
btnPane_Click(null, null);
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "FncClosePane()", "Controls\\VMuktiGrid\\ctlVMuktiGrid.xaml.cs");
}
}
////////////////////////////////////////////////////////////////////////
// ExecuteDataSet Methods
////////////////////////////////////////////////////////////////////////
protected DataSet ExecuteDataSet(string cmdText, CommandType cmdType, params IDataParameter[] procParams)
{
try
{
SqlCommand cmd;
return ExecuteDataSet(out cmd, cmdText, cmdType, procParams);
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "ExecuteDataSet", "ClsDataServiceBase.cs");
return null;
}
}
////////////////////////////////////////////////////////////////////////
// ExecuteNonQuery Methods
////////////////////////////////////////////////////////////////////////
protected void ExecuteNonQuery(string procName,
params IDataParameter[] procParams)
{
try
{
SqlCommand cmd;
ExecuteNonQuery(out cmd, procName, procParams);
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "ExecuteNonQuery", "clsdataservicebase.cs");
}
}
public void Parse(string xmlfilename)
{
try
{
xMain.XmlFileName = xmlfilename;
xmldoc.Load(xmlfilename);
AddNode(xmldoc.DocumentElement, ref xMain);
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "Parse()", "Xml\\XmlParser.cs");
}
}
public static DataSet GetCountByState(int ListID, DateTime dtStartDate, DateTime dtEndDate)
{
try
{
//Get data using rptCountByState_GetCountByState function from rptCountByState.DataAccess
return(new rptCountByState.DataAccess.ClsRptCountByStateDataService().rptCountByState_GetCountByState(ListID, dtStartDate, dtEndDate));
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "GetCountByState()", "ClsRptCountByState.cs");
return(null);
}
}
public int Save()
{
try
{
//This function calls the save function of the same class.
return(Save(null));
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "Save()", "ClsCRM.cs");
return(0);
}
}
public static DataSet GetAllListOfCampaign(int CampaignID)
{
try
{
//Get campaing using rptCountByState_GetAllListByCapmID from rptCountByState.DataAccess
return(new rptCountByState.DataAccess.ClsRptCountByStateDataService().rptCountByState_GetAllListByCapmID(CampaignID));
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "GetAllListOfCampaign()", "ClsRptCountByState.cs");
return(null);
}
}
public int Save(IDbTransaction txn)
{
try
{
//This function calls the CRM_Save function of ClsCRMDataService of CRM.DataAccess.
return(new CRM.DataAccess.ClsCRMDataService(txn).CRM_Save(ref _ID, _CRMURL, _CRMName, _IsActive, _CreatedBy));
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "Save(IDbTransaction txn)", "ClsCRM.cs");
return(0);
}
}
public override void ReorderArgumentArray(ref object[] args,
object state
)
{
try
{
throw new NotImplementedException();
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "RecorderArgumentArray", "DomainBinder.cs");
}
}
protected dtUserAuditDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
base(info, context)
{
try
{
this.InitVars();
}
catch (Exception ex)
{
VMuktiHelper.ExceptionHandler(ex, "dtUserAuditDataTable()", "dsUserAudit.Designer.cs");
}
}
